XL: Subtotals Are Not Recalculated After Displaying Custom View

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, the Subtotal function may not calculate values correctly when you display a custom view.

WORKAROUND

To work around this problem, use one of the following appropriate workarounds.

Microsoft Excel 98 Macintosh Edition

If you are using Microsoft Excel 98 Macintosh Edition, press CONTROL+OPTION+F9.

Microsoft Excel 97

If you are using Microsoft Excel 97, press CONTROL+ALT+F9.

Microsoft Excel 7.0 or Earlier

If you are using Microsoft Excel version 7.0 or earlier, apply the same filter options you initially used to create the view.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about using custom views, click the Index tab in Microsoft Excel Help, type the following text

   views, custom

For more information about using subtotals, click the Index tab in Microsoft Excel Help, type the following text

   subtotals, data