View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Platt Adam Platt is offline
external usenet poster
 
Posts: 1
Default Excel 2003 Subtotal order and grouping incorrect in SP1

I'm using Microsoft Visual Foxpro 8.0 to generate an excel-based report which
uses the subtotal function. After installing Excel2003 SP1, the subtotals no
longer order or group correctly.
Where the total rows should read something like:

Total 2
Total 1
Grand Total

They instead read like:

Total 1
Total 2
Grand Total

Also, the data is not grouped by Total 2. Where on the left hand side there
should be a tree-type view where data can be collapsed/expanded, The total
line for Total 2 is not groupable.

Many other people have had this problem, and there have been two definitive
fixes pointed to:
1. Install the following hotfix
http://support.microsoft.com/kb/833855

2. Add a DWORD value of 1 called Excel97Subtotals into the registry key
HKEY_CURRENT_USER\software\microsoft\office\11\exc el\options

I have tried both, and only had success with editing the registry.
Unfortunately, I need to use a fix that can be mass distributed and applied
by users that have very little computer knowledge. Has anyone else tried the
Microsoft hotfix for this issue and still had a problem? Are there any known
issues about this hotfix?