How to Recover Unsaved Excel and Word Files: 4 Data Rescue Methods

You may lose an unsaved Excel or Word file after a crash, power outage, or accidental closure. Office applications have built-in AutoRecover and Document Recovery features to prevent data loss. This article explains four specific methods to retrieve your work, from checking the recovery pane to searching for backup files on your computer.

How AutoRecover and Document Recovery Work

AutoRecover is a background feature in Microsoft Office that automatically saves a temporary copy of your open file at set intervals. The default interval is 10 minutes. This creates an AutoRecover file, which has an .asd extension for Word and an .xbk or similar temporary extension for Excel. If the application closes unexpectedly, it uses these files to try and restore your work the next time you start the program.

The Document Recovery pane is the interface that appears when this restoration attempt is successful. It lists the original saved file and any recovered versions from the AutoRecover save points. You can then choose which version to open and save. For this system to function, the AutoRecover feature must be enabled, and the file must have been open long enough for at least one automatic save to occur.

Prerequisites for Recovery

Two settings are critical. First, AutoRecover must be turned on. You can verify this in Word or Excel by going to File > Options > Save. Second, the AutoRecover file location must be known. This path is also listed in the Options > Save dialog. Files that were never saved even once have a different storage location, typically a dedicated “UnsavedFiles” folder, which the application can access through the Manage Document menu.

Four Methods to Recover Your Files

Method 1: Use the Document Recovery Pane on Restart

This is the most common and automatic method. After a crash or forced closure, restart Microsoft Excel or Word. If the application detects recoverable data, the Document Recovery pane will open automatically on the left side of the window.

1. Open the application
   Launch Excel or Word normally after the unexpected closure.
2. Review the Document Recovery pane
   Look for a pane titled “Document Recovery” on the left. It will list available files, often showing “[Original]” and “[Recovered]” versions.
3. Preview and open a version
   Hover over each file name to see a preview. Click on the version you want to restore.
4. Save the recovered file immediately
   Once the file is open, go to File > Save As immediately. Choose a location and save it with a proper name. The recovered temporary file will be deleted once you close the application.

Method 2: Recover from the Backstage Info Screen

If the Recovery pane does not appear, or if you closed it, you can manually access unsaved files. This method opens the folder where Office stores temporary copies of files that were closed without saving.

1. Open a new or existing file
   Start Excel or Word. You can open any file or start a new blank document.
2. Navigate to File > Info
   Click the File tab in the top-left corner, then select “Info” from the menu.
3. Click Manage Document
   In the Info panel, look for the “Manage Workbook” button in Excel or “Manage Document” in Word. Click it.
4. Select Recover Unsaved Workbooks/Documents
   A dropdown menu will appear. Choose the “Recover Unsaved Workbooks” or “Recover Unsaved Documents” option. This opens a File Explorer window showing the UnsavedFiles folder.
5. Open and save the file
   Files here have generic names. Sort by “Date modified” to find the most recent one. Select it and click Open, then use File > Save As to save it permanently.

Method 3: Manually Search for AutoRecover Files

If the application fails to start, you can search your computer for the backup files directly. This requires knowing the file extensions and the general save location.

1. Note the AutoRecover file location
   On a working PC, open Excel or Word and go to File > Options > Save. Copy the path listed next to “AutoRecover file location”.
2. Open File Explorer
   Press Windows key + E to open Windows File Explorer.
3. Navigate to the folder and search
   Paste the AutoRecover path into the address bar and press Enter. In the search box within that folder, type “*.asd” for Word files or “*.xbk” for Excel files and press Enter.
4. Identify and copy the correct file
   Sort results by “Date modified”. Look for files with a recent timestamp matching your work session. Copy these files to a safe location like your Desktop.
5. Open the backup file
   Try to open the copied .asd or .xbk file directly with Excel or Word. The application may convert it back to a standard .xlsx or .docx file when you save it.

Method 4: Recover from the Open Dialog Recent List

A shortcut to the UnsavedFiles folder is also available from the Open file dialog. This is useful if you prefer navigating from the Open menu.

1. Go to File > Open
   In Excel or Word, click the File tab and select “Open”.
2. Click Recent
   In the Open panel, ensure “Recent” is selected from the list on the left.
3. Find the recovery link
   Scroll to the very bottom of the list of recent documents. You will see a button labeled “Recover Unsaved Workbooks” or “Recover Unsaved Documents”. Click it.
4. Select and open the file
   This opens the same UnsavedFiles folder as in Method 2. Select the file you need and click Open, then save it permanently.

Common Mistakes and Limitations

AutoRecover Was Disabled or the Interval Was Too Long

If AutoRecover is turned off, no temporary files are created. Always verify the setting in File > Options > Save. A long save interval, like 30 minutes, increases the risk of losing work done since the last save. For critical work, set the interval to 5 or 10 minutes.

Clearing Temporary Files or Disk Cleanup

Running Disk Cleanup in Windows and selecting “Temporary files” can delete the contents of the AutoRecover and UnsavedFiles folders. Avoid using this tool while trying to recover documents. If you have, file recovery software may be needed to scan the drive.

File Never Existed Because It Was Never Saved

If you typed text into a new, blank document and closed it immediately without ever saving, no AutoRecover file exists. The UnsavedFiles folder only contains files that were closed without saving after an initial AutoRecover save had occurred. For a brand-new file, this requires it to be open for longer than the AutoRecover time interval.

Opening the Wrong Backup File Version

The recovery folders can contain many similarly named temporary files. Opening an older version will not contain your most recent edits. Always sort files by “Date modified” in descending order and preview the contents if possible before opening.

Recovery Method Comparison

Item	Document Recovery Pane	Manage Document Menu	Manual File Search	Open Dialog Method
Best For	Immediate recovery after a crash	When the Recovery pane did not appear	When the app won’t start or files are moved	Quick access from the Open menu
User Action Required	Minimal (pane appears automatically)	Navigate File > Info > Manage Document	Search File Explorer for *.asd or *.xbk	Click link at bottom of File > Open > Recent
File Types Found	Recently auto-saved versions of open files	Unsaved files from the dedicated folder	All AutoRecover backup files on the drive	Unsaved files from the dedicated folder
Success Rate	High if AutoRecover was on	High for files closed without saving	Variable, depends on file system state	High for files closed without saving
Primary Risk	Closing the pane without saving	Overwriting the temp file with a new unsaved doc	Accidentally deleting the backup file	Not finding the link in the Recent list

You can now retrieve lost work using the Document Recovery pane or the Manage Document menu. Set your AutoRecover save interval to 10 minutes in File > Options > Save for better protection. For advanced data rescue, use Windows File Explorer to search your entire C: drive for *.asd files if the standard folders yield no results.