Multi-level Subtotals with Excel 5.0 data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We use data imported from a SQL database and saved in Excel 5.0
format to create spreadsheets.

We are currently using Excel 2003, SP1. When we do multi-level subtotals
with new data, they work correctly, but when we try to do the multi-level
subtotals with the data saved in Excel 5.0 format, the totals come out
staggered and in the wrong places.

Is there a workaround for this problem? We have already tried the Hot Fix
831824,
but that didn't help.

Thanks,

Sandy
 
Have you tried 'Save As' in the Excel 2003 format. Close the file. Open the
file and retry?
HTH,
 

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

Subtotal Levels not showing in Excel 2
Excel Subtotal problem 1
Import external data into Excel 2007 so I can subtotal it 2
Subtotals in Excel 2007 TABLES 1
multi-level subtotals are in the wrong position 1
Insert subtotal in a query database Excel 2007 3
nesting sumproduct with subtotal 9
Subtotal - Directorate 2

Back
Top