XL: Subtotals Are Not Recalculated After Displaying a Custom View

ID: Q176861


The information in this article applies to:


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


REFERENCES

Additional query words: XL97


Keywords          : kbtool xladdins 
Version           : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,7.0a,97
Platform          : MACINTOSH WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 30, 1999