Forum Discussion
Excel Auto Recovery Question
Recently used Excel and received the message that the Automatic Recovery has been disabled. What does this mean exactly and how can I enable it again?
This message means Excel has turned off AutoRecover for the current session because it detected a problem (for example, a crash, instability, low disk space, or performance issue). AutoRecover being disabled prevents Excel from periodically saving recovery copies of open files.
What AutoRecover does
AutoRecover automatically saves temporary copies of your work at set intervals so you can recover files after a crash or power loss.
How to re-enable AutoRecover
- Open Excel
- Go to File → Options → Save
- Make sure “Save AutoRecover information every X minutes” is checked
- Ensure “Keep the last AutoRecovered version if I close without saving” is checked
- Click OK
- Close and reopen Excel
If the message keeps appearing
- Check that the AutoRecover file location is valid and writable
(File → Options → Save → AutoRecover file location) - Ensure you have sufficient free disk space
- If using OneDrive or a network drive, test with a local folder
- Restart Excel (or Windows) to reset the session state
Once re-enabled, AutoRecover will resume protecting your files normally.