5: Prevent data loss with AutoRecover and AutoSave
Losing data is almost inevitable.
But you can make the process of recovering the data from an unsaved file a lot less painful if you’re prepared.
We recommend changing just a few settings to help prevent data loss in the future.
The AutoRecover feature saves a temporary version of what you’re doing in Excel every 10 minutes.
If Excel crashes, you can access this temporary version using the solutions I explained earlier.
AutoRecover is active by default. If it somehow isn’t active on your computer, follow these steps:
5.1) Go to ‘File’ and ‘Options’.
5.2) In the ‘Save’ pane, make sure there’s a checkmark in ‘Save AutoRecover information every’ and ‘Keep the last AutoRecovered versions if I close without saving’.
5.3) Here you can also change when Excel should save this temporary version of your Excel file.
The default is every 10 minutes, but you can easily change that. Try 5 instead.
It might not seem like a big difference from 10 minutes, but it can save you a lot of work.
Of course, we recommend saving your changes often. Just hit Ctrl + S to overwrite the previous version of your Excel document.
If you’re the type of person who forgets to do this (like me), you can toggle on ‘AutoSave’ on the top left side of the Excel interface.
AutoSave saves every single change you make in your Excel file – automatically.
And if you overwrite something, read here how you can recover overwritten versions of your Excel files.