Speeding Saving Process

[Guest]

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.

 

[Norman Jones]

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

 

[Guest]

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