Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Polynomial Order Incorrect | Charts and Charting in Excel | |||
Pivot Table Subtotals - Calculated field subtotal incorrect | Excel Discussion (Misc queries) | |||
Y axis box size incorrect in Excel 2003 | Charts and Charting in Excel | |||
Subtotal Order in Excel 2003 | Excel Worksheet Functions | |||
Incorrect Japanese guidance with Excel 2003 | Excel Worksheet Functions |