LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amkazen
 
Posts: n/a
Default Multi Level Subtotals and SP2

Hi, I have searched and read the search results for the problem I am having.
The problem is the subtotals are not being staggered properly, appearing in
their correct groupings, etc.

I have installed SP2.

I have changed the registry as directed per the knowledge base articles. I
have tried setting the value to 0, 1, and 2, without any effect to the
problem.

If I remove from my list of items to be totaled the problem category, the
subtotal function works fine. The offending category is a category that only
has one listing. As an example, I have a financial company category that has
credit unions, banks, savings & loans, etc inside. However, I also have a
land use category that only has parks. I remove the lkand use category,
everything is fine. I leave it in, there subtotals mess up. I have more
than one category like land use.

Any ideas as to why the fixes I have read about and tried are not working to
correct this identified problem? I must be missing something.....

I have XP and Office 2003, with SP2. Thanks in advance for the help.


 
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



All times are GMT +1. The time now is 12:04 AM.

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"