SYMPTOMS
After you install the hotfix that is described in the following Microsoft Knowledge Base
article and configure the
Excel97Subtotals registry entry value to
1, Microsoft Office Excel 2003 reverts to the original ordering
behavior as you expect:
831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003
However, the multiple grand totals that are present in Microsoft Excel
97 for Windows and in Microsoft Excel 2000 are not present. Because the grand totals are not present, there may be interference with solutions that automatically compensate for multiple grand totals.
RESOLUTION
This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix.
Service pack information
This problem is corrected in Office 2003 Service Pack 2.
To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
870924 How to obtain the latest service pack for Office 2003
How to obtain the hotfix
This issue is fixed in the Microsoft Office Excel 2003 post-Service Pack 1 Hotfix Package that is dated August 20, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
840316 Description of the Excel 2003 post-Service Pack 1 hotfix package: August 20, 2004
After you install the hotfix
package, configure the
Excel97Subtotals registry entry to use one of the following values:
- If you use the 0 value:
- The change in the display order of the summary and the detail data that is enabled by the hotfix that is described in Knowledge Base article 831824 is in effect.
- The removal of multiple grand totals that is enabled by the hotfix that is described in Knowledge Base article 831824 is in effect.
- If you use the 1 value:
- The order of the summary and the detail data appears as it did before you applied the hotfix that is described in Knowledge Base article 831824.
- The removal of multiple grand totals that is enabled by the hotfix that is described in Knowledge Base article 831824 is in effect.
- If you use the 2 value:
- The order of the summary and the detail data appears as it did before you applied the hotfix that is described in Knowledge Base article 831824.
- The multiple grand totals behave as it did before you applied the hotfix that is described in Knowledge Base article 831824.
To configure the
Excel97Subtotals registry entry, follow these steps.
Note The behavior that is enabled by this hotfix is considered a temporary measure to give users time to modify solutions that compensate for the behavior that is changed in the hotfix that is described in Knowledge Base article 831824. Later versions of Microsoft Excel may not support multiple grand totals.
- Quit all the Microsoft Office programs that are running.
- Click Start, click
Run, type
regedit in the Open box, and then click OK.
- Locate and then click to select the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
- In the right pane, right-click
Excel97Subtotals, and then click
Modify.
- In the Value data box, type
the value that you want to use, and then click OK.
- On the File menu, click
Exit to quit Registry Editor.