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.

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

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

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

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

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

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.

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