.. Question ..
I am having trouble with subtotals in the 2002 and 2003 versions of Excel. Some of the Peoplesoft reports results are effected.

.. Answer ..
We have had several clients experience problems with Excel subtotals in the 2002 and 2003 versions of Excel. Over last weekend (4/15) some persons have reported this issue

We found two Knowledgebase articles about this and also confirmed these with Microsoft. Basically, people need to apply a fix and make a registry change that changes the functionality of the subtotals back to what they were in Excel 97. Microsoft plans to fix the problem and, this change is slated for the next release of Excel.

Listed below are the links to the two Microsoft Knowledge Base articles that should help the Excel problem.

1. The link to the Knowledge Base article for the subtotal fix for Excel 2003 is: http://support.microsoft.com/kb/831824/

2. Additionally there is a supplemental article for a fixing grand totals and the link for this is: http://support.microsoft.com/kb/870757

Created on: 4/20/2005