Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jake-M
 
Posts: n/a
Default KB 831824 does not completely solve the Subtotals Bug !!

There are too many postings on this to reply to every one.

Implementing the instructions in 831824, there are still occasions where
this bug occurs. I have a simple example I'd be happy to e-mail anyone upon
request to jacob dot moskowitz at db dot com. I'm goiing to try calling
Microsoft again about this, but it looks like I'll have to implement the
whole subtotals function in VBA. In the past, I also had a post-subtotals
VBA kludge to reposition the sub-headings rows, but it was imperfect, then
831824 , and it worked for 2 levels. After I added a third level, it fails
in about 5% of the cases.

Reply
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
How do i copy only the subtotals inserted into a list? scross88 Excel Discussion (Misc queries) 2 January 25th 06 06:53 PM
Applying formulas only to the subtotals of a data list KG Excel Discussion (Misc queries) 5 September 10th 05 11:16 PM
Solve Order of a CalculatedField in a Pivot Table Gary L Brown Excel Discussion (Misc queries) 0 August 25th 05 01:58 PM
How do I copy an outline w/ subtotals & paste just the subtotals av Excel Discussion (Misc queries) 1 June 20th 05 11:35 PM
Excel gets subtotals out of order using multiple sorts and subtot. jeffl Excel Discussion (Misc queries) 1 March 29th 05 01:35 AM


All times are GMT +1. The time now is 10:49 AM.

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

About Us

"It's about Microsoft Excel"