Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Speeding Saving Process
Excel saves take nearly 10 minutes, how can I quicken the process. Or, what
should I look at to determine why it is taking so long. |
#2
|
|||
|
|||
Hi Carobar,
One or more sheets in your workbook may have a used range which is larger than you expect or intend. See Debra Dalgleish's notes at: http://www.contextures.com/xlfaqApp.html#Unused --- Regards, Norman "Carobar" wrote in message ... Excel saves take nearly 10 minutes, how can I quicken the process. Or, what should I look at to determine why it is taking so long. |
#3
|
|||
|
|||
How big is your workbook in terms of MB ?
Also, try to eliminate big sections of VLookup formulas as I find them the worst offenders. They can often be replaced with a SumProduct formula which I would be happy to help with if you post some of your formulas here. Phil "Carobar" wrote: Excel saves take nearly 10 minutes, how can I quicken the process. Or, what should I look at to determine why it is taking so long. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Saving shared Excel files | New Users to Excel | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Simplify Process with Excel 2003 | New Users to Excel | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |