LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Polynomial Order Incorrect Darren Charts and Charting in Excel 7 October 23rd 09 04:42 PM
Pivot Table Subtotals - Calculated field subtotal incorrect reddy Excel Discussion (Misc queries) 3 August 26th 08 02:37 AM
Y axis box size incorrect in Excel 2003 lcaretto Charts and Charting in Excel 1 July 24th 07 08:52 AM
Subtotal Order in Excel 2003 bakerdmw Excel Worksheet Functions 0 November 17th 06 03:41 PM
Incorrect Japanese guidance with Excel 2003 j-mura Excel Worksheet Functions 0 March 5th 05 10:41 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"