Microsoft KB Archive/176861

= Subtotals Are Not Recalculated After Displaying a Custom View =

Article ID: 176861

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 95a
 * Microsoft Excel 5.0a for Macintosh
 * Microsoft Excel 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.

