Subtotals Are Not Recalculated After Displaying a Custom View (176861)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for Windows 95 7.0a
  • Microsoft Excel for the Macintosh 5.0a
  • Microsoft Excel for Windows 5.0c
This article was previously published under Q176861

SYMPTOMS

The Subtotal function may not calculate values correctly when you display a custom view.

WORKAROUND

To work around this problem, use the appropriate method for your situation.

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 that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

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

views, custom

and then double-click the selected text to go to the "custom views" topic.

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

subtotals, data

and then double-click the selected text to go to the "insert subtotals into a list" topic.
Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbbug KB176861
©2004 Microsoft Corporation. All rights reserved.