Microsoft KB Archive/870757

= Multiple grand totals are missing after you set the Excel97Subtotals Windows registry value =

Article ID: 870757

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft Office XP Service Pack 1

-





SYMPTOMS
After you install the hotfix that is described in the following Microsoft Knowledge Base article and configure the  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  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  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:

 

 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.</ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

This problem was first corrected in Office 2003 Service Pack 2.

Additional query words: KbOffice2003postSP1fix

Keywords: kbqfe kbhotfixserver kboffice2003sp2fix kboffice2003presp2fix kbbug kbfix KB870757

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.