| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Why are subtotals so slow in Excel 2002 SP-2?
We've recently got new hardware and have upgraded from 97 to 2002 (sp2) and a
spreadsheet that was working fine now takes too long to add subtotals to a few hundred rows of data. Nothing has changed in the spreadsheet so why the poor performance? |
|
#2
|
|||
|
|||
|
I don't know why you'd experience such a difference between versions.
Instead of subtotals, you may find it easier, and more flexible, to use a Pivot Table to summarize the data. There are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Confused? Me too! wrote: We've recently got new hardware and have upgraded from 97 to 2002 (sp2) and a spreadsheet that was working fine now takes too long to add subtotals to a few hundred rows of data. Nothing has changed in the spreadsheet so why the poor performance? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Hybrid Mode
