When you are working on an important spreadsheet in Microsoft Excel, the last thing you want is for a sudden power outage or system crash to erase hours of work. To prevent this, Excel has a robust autosave feature that runs in the background, quietly protecting your data. However, unlike a traditional save where you choose the location, these automatic backups are stored in a specific hidden folder on your computer, separate from the original file.
Understanding the Excel Autosave Mechanism
Modern versions of Excel, particularly those part of Microsoft 365 and Excel 2016 or later, utilize a feature called Autosave. When Autosave is enabled, which it is by default in Office 365 applications, Excel automatically saves a recovery version of your document at regular intervals without interrupting your workflow. This is distinct from the older AutoRecover feature, which created temporary snapshots that were often deleted when the program closed unexpectedly.
The Role of the Backup File
Think of the autosaved file as a secure, temporary shadow of your active document. While you are editing "Budget.xlsx" live on your desktop, Excel is simultaneously writing a locked, temporary version of that file to a protected system directory. This backup remains inaccessible and hidden until Excel detects a problem. If you close the file normally or save it manually, Excel usually discards this temporary backup to keep your system clean.
Locating the Autosave Data on Windows
If you need to recover an unsaved document because Excel crashed before you could close it properly, you must navigate to the temporary storage location. The exact path is usually deep within the AppData folder, which Windows hides by default to prevent accidental deletion. You can access this folder quickly by using the Run command.
Press Windows Key + R to open the Run dialog.
Type %localappdata%\Microsoft\Office\UnsavedFiles and press Enter.
This command takes you directly to the folder where Excel stores orphaned recovery files. Note that the exact path may vary slightly depending on your version of Windows and Office, but the "UnsavedFiles" directory is the primary target for these recovery attempts.
Accessing Files on MacOS
Users of Apple computers will find the storage location different due to the distinct operating system architecture. On MacOS, temporary autosaves are not usually visible in the same way as Windows temp files. Instead, they are often stored within the application package itself or in a specific temporary folder that the system manages.
Open the Finder and navigate to the Go menu.
Hold down the Option (Alt) key to reveal the Library option.
Browse to Containers\com.microsoft.Excel\Documents\AutoRecover\ .
Alternatively, if you are trying to recover a file after a crash, you can open Excel directly. The application often prompts a recovery session at launch, listing all available unsaved workbooks that you can restore.
Recovering an Unsaved Workbook
Knowing where the files are stored is only half the battle; you must know how to retrieve them. When Excel shuts down unexpectedly, the next time you launch the program, it usually opens the "Document Recovery" pane automatically. This pane acts as a dashboard, displaying all the salvaged autosaved versions of your work.
If that pane does not appear, you can manually search for it. Go to the File tab, select Open , and then choose Recover Unsaved Workbooks . This action scans the temporary directories and allows you to browse the contents of the Autosave folder directly from the standard Open dialogue box.
