How to Recover Missing Changes from an Excel Workbook Embedded in OneNote
Question details
The user needs to recover unsaved edits and missing worksheets from an Excel file that was embedded in OneNote before the computer unexpectedly restarted.

- Product
- Microsoft Excel, Microsoft OneNote
- Device & OS
- not provided
- Scenario
- A computer restart caused recent edits to an embedded Excel workbook in OneNote to be lost, and the file is missing from Recent Files.
- Observed behavior
- Changes made to the embedded workbook are missing, and the file cannot be located in standard save directories or the recent files list.
Ensure both Microsoft OneNote and Excel are completely closed before starting the recovery process to prevent further temporary file overwrites.
Search for Temporary Excel Files on the Local Drive
Locate the hidden temporary files created when OneNote extracts an embedded workbook to your local storage.
When you open an embedded Excel file from OneNote, it is temporarily saved to your local drive. If a restart occurs, the original temporary file might still exist even if OneNote fails to recognize the changes.
Press Windows Key + E to open File Explorer on your computer.
Navigate to 'This PC' and double-click your C: drive. In the top-right search bar, type '*.xlsx' and press Enter.
Click the 'Date modified' column header to sort the search results. Look for files modified around the time of the computer restart.
Right-click the suspected temporary file, select 'Copy', and paste it onto your Desktop or another safe folder before opening it to check for missing changes.

Check Excel AutoRecover and Unsaved Files Directory
Use Excel's built-in recovery tools to find automatically saved drafts of your workbook.
Try WPS Office for Reliable Spreadsheet Management
Stop worrying about lost temporary files from complex object embedding. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office with built-in robust Auto Backup features to keep your data secure.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly with full formatting support.
- 3. Enable Auto Backup: Go to Settings > Backup Settings to customize auto-save intervals and secure your ongoing work automatically.

Frequently Asked Questions
Why did my embedded Excel file in OneNote lose its changes?
Opened embedded files are stored in a temporary folder. If Excel remains open without saving back to OneNote properly before a restart, OneNote may fail to sync or recognize those temporary changes.
Does AutoSave work for files embedded in OneNote?
No, Microsoft's AutoSave feature generally only works for files saved directly on cloud platforms like OneDrive or SharePoint, not for local temporary files created by OneNote embedding.
Where is the default Excel AutoRecover location?
By default, AutoRecover files in Windows are typically stored at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can navigate there to manually look for recovered drafts.




