A customer of mine recently had a problem with Excel 2000 – yes lots of people are still using Office 2000 as it’s very fast and does most of what they need. It had crashed and they hadn’t saved their changes in a few hours.
Now, if this had been Office 2003/2007 the next time they opened Excel it would have prompted them with an “AutoRecovered” version of their file. By default Excel 2003/2007 AutoRecover an open worksheet every 10 minutes – this can be changed.
But this didn’t seem to be the case with Excel 2000. I had thought it was available in Excel 2000 but nothing could be found in Tools | Options. It was there in Word 2000 in Tools | Options | Save so what was the deal?
Turns out that, by default, AutoRecover isn’t installed in Excel 2000. It’s there as an Add-In. You must first install the Add-In by going to Tools | Add-Ins and choosing the “Autosave” Add-In. Once this installs you’ll see the Autosave option in the Tools menu. Clicking it will allow you to configure the time interval and whether all sheets or just the active sheet should be accounted for.
How bizarre, and how frustrating for my customer, that this feature was available but not put there by default. Very annoying.