How to Completely Disable ‘AutoRecover’ (Background File Saving) in Microsoft Excel

Microsoft Excel includes a safety feature called “AutoRecover.” By default, every 10 minutes, Excel pauses whatever you are doing, locks the user interface, and silently writes a complete backup copy of your current workbook to a hidden folder on your C:\ drive. If Excel crashes or your computer loses power, you can use this AutoRecover file to restore your lost data.

While this is an absolute lifesaver for standard users, it can be a nightmare for data analysts working with massive datasets. If you have a 500MB workbook filled with millions of rows, complex Power Queries, and array formulas, the AutoRecover save process can take 30 to 60 seconds to complete. During this time, Excel completely freezes, interrupting your workflow with a “Saving…” progress bar. If you are already saving your files directly to a cloud-synced folder (like OneDrive or SharePoint, which handles version history automatically), or if you are running heavy macros that get interrupted by background saves, you must completely disable the AutoRecover engine to reclaim your performance.

Disabling AutoRecover via Excel Options

You can turn off this background daemon globally, stopping Excel from ever attempting an automated backup again.

1. Open the Microsoft Excel desktop application.
2. Bypass the Start Screen by clicking Blank workbook to enter the main editing interface.
3. Look at the main menu ribbon at the top of the screen and click on File (in the top-left corner).
4. Scroll to the absolute bottom of the left-hand blue sidebar and click on Options.
5. A new Options window will appear. In the left-hand menu, click on Save.
6. In the main panel, look at the very top section labelled “Save workbooks.”
7. You will see a checkbox labelled Save AutoRecover information every 10 minutes.
8. Click the checkbox to completely uncheck it.
9. Notice that the option below it (“Keep the last AutoRecovered version if I close without saving”) will automatically grey out.
10. Click the OK button at the bottom of the window to save your changes.

The change takes effect immediately. Excel will no longer freeze every 10 minutes to dump a massive temporary file to your hard drive. However, because you have removed the safety net, you must remember to manually press Ctrl + S to save your work, or rely entirely on your cloud provider’s real-time AutoSave functionality if working off a network drive.