Saving takes 30 Seconds

  • Thread starter Thread starter adambush4242
  • Start date Start date
A

adambush4242

On several different programs that I used saving will randomly take about 30
seconds. This doesn't happen on every save, but it seems to be happening
more and more often. Any ideas?

Thanks

Adam Bush
 
These types of issues are often difficult to troubleshoot. Plus this
question probably belongs on the Microsoft Windows discussion group rather
than the Excel General discussion group. But before heading over there, try
running Disk Cleanup and Disk Defragmenter (Start - Programs - Accessories -
System Tools).
 
Probably more often as your TIF and Temp folders get more crowded.

Try a cleanup of these folders.


Gord Dibben MS Excel MVP
 
What if this happens on several different computers? It seems to be
connected to a certain worksheet. Are there any properties of the worksheet
that would cause the saving to be slow?

Thsanks

Adam Bush
 
Wuich is about 10MB.

Not overly large but could have a lot of calculations taking place when you save
if calculation mode is set to manual and "recalculate before saving"


Gord
 
If there are a lot of formulas (esp array formulas), fonts, etc, some
workbooks can slow to a crawl when autofiltering, saving, etc. Even
some of my workbooks that have only 50 or so array formulas have
noticeable slowdown. Check out the link Gord posted, some very good
information on there about what Excel is doing and how it can be sped
up. I would also recommend http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm.


HTH,
JP
 
Back
Top