Nested subtotals in incorrect order on large worksheets

W

'Wyn

I have found that the higher level subtotals are in the wrong order on long
spreadsheets. Has anyone else got this problem or solved it?
 
R

Robert Lyons

Unfortunately the hot fix for this problem doesn't work, instead you actually have to go into the registry and manually revert to the code for Excel 97 and Excel 2000

There is a Microsoft article that tells you how to do this. #831824 that you can get by going on line help and typing "Multilevel subtotals are in the wrong position"

There also a companion article that tells you how to back up your registry before you try this.

Bob Lyons - 434.972.4137
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Fields Nested Too Deeply" Error in Simple Word Document 5
Excel 2007 - Outline not displaying all nested subtotals 0
Original subtotals should not be within nested subtotals in excel 1
Publisher 2019 Format Picture window size too large to display OK button 0
Microsoft word: fields are nested too deeply 1
Nested table subtotals 1
Page numbering with Merged Document and IF statements 1
MS Word List Bug 0

Top