| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multi-level Subtotals with Excel 5.0 data
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 |
|
#2
|
|||
|
|||
|
Have you tried 'Save As' in the Excel 2003 format. Close the file. Open the
file and retry? HTH, -- Gary Brown "Sandy M" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
