Home » Questions » Computers [ Ask a new question ]

Is there any way of making Excel 2007 do BACKGROUND autorecover saves like MS Word does?

Is there any way of making Excel 2007 do BACKGROUND autorecover saves like MS Word does?

I have a huge Microsoft Excel document - it is currrently about 25Mb in binary format (.xlsb)...the standard Excel format was too large and slow - but is still growing at a steady rate. (It has probably 1000-2000 worksheets and more get added daily)

Asked by: Guest | Views: 71
Total answers/comments: 1
Guest [Entry]

"According to this knowledge base article AutoRecover is also triggered by making changes and leaving Excel idle for more then 30 seconds.

So far every document on the process I have read mentions that AutoRecover is already done in the background, since from my own experience I know it is, so the reason it is slow I can only assume has to do with the size of the file and the location it is saving to.

Unfortunately apart from extending the time limit I can't think of any other way in your particular case that you can speed up this process.

Out of interest, I would assume you have quite a beefy machine for doing this work, since more memory might make a small dent in the process?"