Identify Which Kind Of Excel Work You Lost
Losing an Excel workbook can mean losing the entire file or losing changes to an existing file. The difference matters because Excel offers several recovery mechanisms, and each starts from a different kind of saved information. Before performing repairs or downloading recovery tools, determine what actually happened.
If you created a new workbook and never selected Save, Excel may have retained an automatically generated recovery copy. If you edited a workbook that you had already saved, the last saved file may still be accessible while some later edits are missing. If you worked in a supported Microsoft 365 workbook stored on OneDrive or SharePoint, AutoSave and version history may have preserved changes independently of the traditional desktop recovery process.
Write down the approximate time you last saw the correct workbook, the project or filename, the device and account you used, and whether Excel closed unexpectedly or you deliberately closed it. Note whether you were working in desktop Excel for Windows, Excel for Mac or Excel for the web. The exact menus in this guide primarily describe desktop Excel for Windows; cloud version history is a separate route.
Avoid repeatedly creating a new workbook with the same name, clearing temporary files or overwriting an older saved document. If the workbook is still open and its missing information is visible, save an independent copy immediately instead of restarting Excel just to see whether recovery is available.
The most important principle is that no recovery command can reconstruct edits that were never written to any usable recovery, saved or backup copy. You can often recover some or all of the work, but the outcome must be verified against what the workbook contained before the loss.
Preserve Available Files Before Starting Recovery
If a workbook already exists on the computer, locate it through File Explorer without making unnecessary changes. Check its modified time, folder and file extension. A workbook with a familiar name in a different location may not be the version you edited. Excel’s Recent list can help locate a previously opened file, but you should verify its actual storage location.
When the original workbook is accessible, copy it to an independent, authorized location before attempting to replace or repair it. Give the copy a name that clearly identifies its status, such as Quarterly Report Original Copy. Preserve the correct extension and avoid editing the only remaining version. If it belongs to a shared project, follow the organization’s approved storage and confidentiality arrangements.
If the workbook is open in Excel and contains material you want to keep, use Save As or Save a Copy as appropriate to create a new file. Microsoft explains the distinction between saving and creating a separate copy in its Office recovery overview. Be careful not to confuse a new filename with a verified independent backup if both files remain on the same failing drive.
Do not run disk cleanup, uninstall Office or use a system reset while you are looking for recovery files. Those procedures are intended for other problems and may complicate a recovery attempt. If the physical storage device is repeatedly disconnecting or reporting serious read errors, protect accessible data or consult a qualified recovery specialist before running intensive diagnostics.
For a business workbook, communicate with other authorized collaborators before restoring an old version. They may have made useful changes after the time you last saw the correct file. Preserving the original state before any restore makes comparison and selective reconciliation much easier.
Recover A Workbook That Was Never Saved
Desktop Excel includes a menu for examining available recovery copies of workbooks that were never saved normally. This is the best initial route when you created a new workbook, entered information and then closed Excel or experienced an unexpected shutdown before assigning the file a permanent name.
Open Excel and navigate to File, then Info. Locate the Manage Workbook menu and choose Recover Unsaved Workbooks if the option is available in your version. Some installations also expose the recovery option from the Open area. Microsoft’s earlier Office file version instructions describe the supported recovery route, including opening a recovered workbook and saving it under a proper filename.
A file selection window will display any available recovery copies. Examine the filenames and modification times to identify a likely candidate. An automatically created workbook may have a generic name rather than the project title you normally use. Select an appropriate candidate and open it in Excel.
Inspect the actual worksheets before deciding whether you recovered the right file. If the workbook contains the expected material, immediately use Save As and choose a meaningful filename and authorized location. If several plausible recovery copies exist, save separately named copies of each relevant candidate rather than overwriting the first one.
For example, suppose you created an invoice worksheet at 10:00 and Excel closed unexpectedly at 10:25. A candidate timestamped 10:18 might contain much of your work but not the last few entries. The example is illustrative: the existence and timestamp of a recovery copy depend on the actual saving behavior.
If the recovery list is empty, do not assume that Excel has hidden a perfect backup somewhere else. Check the configured recovery location and other applicable storage routes, but understand that a never-saved workbook may be unrecoverable if no usable recovery copy was created.

Check The Document Recovery Pane After An Excel Crash
When Excel closes unexpectedly, it can display the Document Recovery pane the next time it opens. Depending on the situation, the pane may contain a previously saved workbook, a recovery copy or more than one candidate. This is useful after a power loss, an unexpected application closure or a similar interruption.
Launch Excel normally and inspect the pane if it appears. Do not dismiss it immediately. Examine the names and timestamps of the available entries. Microsoft’s Microsoft 365 recovery guidance explains how to open, inspect and save recovery candidates, and why it is important to review them before removing unwanted entries.
Open the candidate that appears most relevant and check the actual worksheet contents. A newer timestamp is a useful clue, but the latest candidate is not necessarily the correct one if it contains unintended changes. Keep a separate copy of any version that could contain valuable information.
For a complex workbook, review not just the first visible sheet but also other tabs, formulas and important totals. Save the relevant candidate under a new name. Where the pane offers the option to keep recovery files available for later review, choose that cautious option if you are uncertain whether all needed material has been saved.
If you accidentally closed the pane or it did not appear, try the Recover Unsaved Workbooks route where appropriate. Also inspect the existing saved workbook and its recovery versions. The absence of the pane does not establish that every other recovery route is unavailable.
Avoid restarting Excel repeatedly while trying to identify a candidate. Recovery files are temporary by nature, and their availability can change. Once you find useful material, preserve it as an ordinary independently named workbook rather than relying on the recovery pane as permanent storage.
Recover Changes To A Previously Saved Workbook
When a workbook already has a permanent filename, the task is often to recover changes made after the last ordinary save. Start by opening the correct existing file, preferably after preserving an independent copy. Verify that you are working with the intended version and not a template or a duplicate from another folder.
In desktop Excel, select File and Info, then inspect the available Manage Workbook information. When Excel has retained an appropriate recovery version, it may show an entry associated with closing without saving. Select that entry to inspect the earlier recovery state.
Microsoft’s recovery instructions describe a Restore action that can replace the previously saved contents with the selected recovery version. Before choosing an operation that overwrites an existing file, confirm that the original has been protected and that the candidate actually contains the material you need. If possible, save the recovery candidate separately and compare the two files before committing to a replacement.
For example, an existing monthly expense workbook may contain 200 transactions, while a recovered version contains 225. Rather than assuming the newer candidate is perfect, check whether its extra transactions are valid and whether it has unintentionally changed existing formulas. If the original contains corrections missing from the recovered copy, you may need to reconcile specific rows rather than replace the entire file.
If no suitable recovery entry is listed, check whether the file was stored in a cloud location with version history or covered by an independent backup. Those mechanisms may capture different moments in the workbook’s life.
Keep the original and recovered versions clearly identified until all necessary information has been verified. A successful recovery is not simply the appearance of a newer filename; it is the restoration of correct, usable content with the least unnecessary loss of other work.
Restore A OneDrive Or SharePoint Workbook Version
If the workbook was stored in a supported OneDrive or SharePoint location, the file may have a version history. This can be useful when an earlier state contained information that is missing from the currently saved workbook. It is a separate mechanism from finding an unsaved local recovery file.
Open the intended workbook in Excel and inspect File, Info and Version History where available. You may also be able to reach the file’s version history from the appropriate OneDrive or SharePoint interface. Microsoft describes the supported process in its previous-version restoration guide.
Review the available dates and open or preview the relevant candidate. Confirm that the earlier version contains the needed worksheets or values. If you only need a small range of deleted information, consider preserving the earlier version as a separate copy and transferring the necessary material using an appropriate authorized method.
Restoring the whole earlier workbook can also affect valid changes made after that version was captured. This is particularly important for shared files. Coordinate with other editors before restoring a version that might replace their current work. Retain a copy of the current workbook first when your organization’s rules permit it.
If the workbook should be in OneDrive but the desired changes never appeared online, check the account, file location and synchronization condition. Our OneDrive synchronization guide explains how to distinguish a local file from information that has finished uploading.
A cloud version history is limited to available versions and applicable retention arrangements. It does not guarantee a record of every keystroke or every unsynchronized local change. If the required version is missing, examine applicable local recovery copies, authorized backup systems and the service’s support options rather than claiming that an unavailable version can be restored.
Check The Configured AutoRecover Location
Excel’s recovery settings can identify the folder used for automatically generated recovery information. This is useful when the ordinary recovery menu is unavailable or you need to understand where the application was configured to keep its temporary copies. Do not assume the same folder path applies to every account, Office version or managed computer.
Open File, Options and Save in desktop Excel for Windows. Inspect the AutoRecover file location shown in the settings. Write down the existing value before changing anything. Microsoft’s workbook recovery and repair guidance includes the relevant recovery configuration and distinguishes it from ordinary workbook backup copies.
If you are troubleshooting a currently open workbook, save any accessible work first. On a computer you are authorized to use, open the specified folder through File Explorer using the exact location displayed by Excel. Inspect plausible items by timestamp and name while taking care not to delete or move unrelated files.
An AutoRecover folder does not necessarily contain a permanent readable copy of every workbook you have opened. Some items are temporary or belong to another recovery process, and Excel may remove obsolete recovery information. Do not infer the existence of a lost workbook from the presence of the folder alone.
If you locate an apparent relevant file that can be read through supported Excel controls, preserve a copy before trying to use or repair it. Avoid changing file extensions at random or attempting to open an unknown executable file presented as recovered spreadsheet data.
For a computer with organizational storage restrictions, ask the administrator about the configured recovery folder and approved backup arrangements. Do not enter another user’s profile or expose confidential files simply because a recovery folder contains generic filenames. The settings page is primarily a way to inspect the actual recovery configuration for the device and account you are using.
Distinguish An Unsaved Workbook From A Deleted Or Corrupted File
A workbook that was saved and later deleted is not the same problem as a never-saved workbook. First verify that the expected file is genuinely missing from its intended location rather than renamed, moved or stored under another account. Search the relevant folder and check any recent-file references available in Excel.
For a locally deleted file, inspect the Recycle Bin if the storage arrangement supports it. For an authorized cloud location, inspect the service’s corresponding deletion recovery controls. A deleted network file or a file removed from external storage may not appear in the ordinary local Recycle Bin. Your independent backup may be the most reliable available source.
If a workbook exists but Excel reports damage or cannot open it, preserve a separate copy before attempting a repair. Microsoft’s corrupted workbook documentation describes Open and Repair for appropriate files. Use the supported method on a copy where practical, examine any reported repair details and avoid assuming that recovered data is complete.
A repaired workbook might no longer contain certain original features or information. If the repair process removed a damaged part of the file, you need to verify whether the resulting document still serves its intended purpose. Do not automatically replace every existing copy with the repaired version.
Our Windows backup software guide discusses independent backup considerations. If storage itself appears unstable, our SSD health guide explains the difference between device health information and file-system problems.
Do not download an unknown spreadsheet recovery utility solely because the ordinary menu is empty. Such software cannot guarantee recreation of material that never existed on storage, and uploading a confidential workbook to an unverified service can expose its contents. Start with the mechanism appropriate to the demonstrated loss.
Understand AutoSave AutoRecover And Manual Saving
AutoSave and AutoRecover sound similar, but they serve different functions. Understanding the distinction helps explain why a recovery candidate may contain older information than you expected. It also helps you establish a better workflow after recovering an important file.
AutoSave in supported Microsoft 365 desktop applications regularly saves changes to eligible cloud-stored files. Microsoft’s AutoSave explanation describes the relevant subscription and storage requirements. The feature is not necessarily available for every local workbook, file format or Office installation.
AutoRecover periodically retains recovery information intended to help after an interruption. Its usefulness depends on the configuration, whether the recovery operation completed and whether the resulting file remains accessible. It does not replace the deliberate creation of an ordinary saved workbook.
Manual saving is the action of saving the file you intend to retain. Press Ctrl + S regularly in desktop Excel and establish a proper filename and storage destination early in the project. If you are making an experimental change to an existing cloud workbook with AutoSave active, create a separate copy before beginning your experiment rather than assuming that closing the file will discard the edits.
Consider three illustrative cases. A never-saved workbook may depend on AutoRecover. A local workbook saved at 11:00 may have an ordinary saved version plus additional recovery information. A supported shared cloud workbook may have a current saved state and older versions available through its history. Each requires a different recovery decision.
The word saved should always be tied to an actual file or service state. A visible recovery entry is not equivalent to a verified backup, and cloud synchronization does not necessarily protect against every unwanted deletion or change. Use the appropriate tools together rather than relying on one feature to cover all types of loss.
Reconcile Formulas Data And Workbook Features After Recovery
Recovering a workbook does not finish the task if you cannot trust its results. Excel files can contain formulas, tables, named ranges, charts, links, pivot tables, macros and other information whose condition is not obvious from the first sheet. Inspect the material according to the purpose of the workbook.
Start with the worksheets and ranges containing the most valuable data. Check recent entries against an independent source when possible, such as approved transaction records or a previously exported report. Compare the label, units and date range of important totals rather than just their numbers.
Inspect key formulas in the formula bar. A value that appears correct may be stale, a pasted value, or the result of an outdated calculation. Recalculate using supported Excel controls when appropriate and observe whether totals remain consistent. Do not enable external data refresh or macros automatically merely to make a recovered workbook appear complete.
If the workbook uses authorized external links, understand whether those sources remain accessible and appropriate before updating them. A recovery candidate copied from another location may have a different connection environment. Preserve the original workbook format, particularly for a file that legitimately contains macro-enabled features; saving to a format that cannot store them may remove functionality.
Compare the recovered workbook with the latest independently saved version. Where necessary, reconcile specific changes instead of replacing the entire newer file. For instance, an older recovery copy may contain a missing worksheet while the newer original contains correct recent data on other sheets.
Save a verified recovery candidate under a meaningful project name and retain the independent originals until the comparison is complete. Document missing information clearly instead of silently inventing entries or approximating important calculations. For financial or operational work, ask the responsible owner to review the reconstructed content before treating it as final.
Configure Recovery And Reduce Future Workbook Loss
After you have protected the recovered information, review Excel’s future recovery arrangements. In desktop Excel for Windows, open File, Options, Save. Verify that AutoRecover is enabled where appropriate and inspect the interval and storage location. Microsoft’s crash protection guidance explains these options, including preserving the last automatically recovered version when closing without saving.
Choose an interval appropriate to the amount of work you perform and the performance of the system. A short interval can reduce the amount of work between successful recovery snapshots, but no interval guarantees recovery after every possible failure. Information created before the first recovery operation or during a failed write may still be lost.
Create a meaningful ordinary file when starting a new spreadsheet. Save regularly and use separate versions for substantial revisions when that suits the workflow. For supported cloud files, understand when AutoSave operates and verify that the file is actually stored in the intended account. Coordinate sharing and version restoration with collaborators.
Establish independent backups for important local and cloud information. Test whether you can open a representative backed-up workbook and verify its data. Our file backup guide covers related preparation for system changes.
If Excel repeatedly crashes, document the application version, workbook characteristics and circumstances, and seek supported troubleshooting after preserving your files. System repair is a separate task, not a substitute for recovering an unsaved document.
The recovery workflow in this article is based on official Microsoft documentation and original diagnostic examples. The illustrations are conceptual rather than screenshots, and the procedures were not independently executed in a live Excel installation for this article. A recovered file should be treated as provisional until its contents have been checked against the original requirements.
Frequently Asked Questions
Can Excel Recover A Workbook That Was Never Saved?
Sometimes. Check Recover Unsaved Workbooks and the Document Recovery pane where applicable. Recovery requires an available usable copy.
Where Is Recover Unsaved Workbooks In Excel?
In supported Windows desktop Excel, look under File, Info, Manage Workbook. Menu placement can vary by version.
What If Recover Unsaved Workbooks Shows Nothing?
Check other applicable recovery routes, including the configured AutoRecover location, saved files and cloud history. There may be no recoverable copy.
Is AutoSave The Same As AutoRecover?
No, AutoSave regularly saves eligible cloud files, while AutoRecover retains temporary recovery information for supported circumstances.
Can I Restore Only One Worksheet From An Older Version?
Preserve a separate copy of the older workbook and compare or transfer the needed information using appropriate supported methods. Verify formulas and dependencies.
Will Restoring An Earlier Version Replace Recent Changes?
A full version restore can replace the currently saved state. Preserve the current file and coordinate with collaborators first.
Does A Recovered Workbook Contain Every Recent Edit?
Not necessarily. Inspect its content and timestamps, verify important calculations, and reconcile any missing work from independent records.



