The location of Excel temp files is not one universal folder. Excel may keep an AutoRecover copy in its configured location, offer an unsaved workbook through its own menu, or create temporary working files beside a saved workbook. The right place depends on whether the workbook was ever saved and what happened before it disappeared. Start inside Excel, because a file named like a temp copy may not be a complete, openable spreadsheet. Do not overwrite the original or rename random temporary files while you are still looking for a good copy.
Choose the search path that matches your loss
If Excel closed unexpectedly and the workbook had unsaved changes, reopen Excel first. Look for a Document Recovery pane and compare any offered versions by timestamp and content. Save a promising copy with a new name on a healthy location. Do not click Save over the only original until you have checked that the sheets and formulas you need are present. A recovered version may be older than the last edits you remember.
If the workbook was never saved at all, use Excel’s own unsaved-workbook command. Open Excel, choose File > Info, open Manage Workbook or the equivalent Manage Document control in your version, and select Recover Unsaved Workbooks. Microsoft’s Office recovery instructions describe that route. Open any candidate and immediately use Save As to a new name. If nothing appears, the absence of an entry does not prove a hidden temp file exists elsewhere.
If a previously saved workbook is missing from a folder, first confirm the Windows account, the recent-files entry, and the cloud or network location used for the last save. Search by part of the filename and .xlsx or .xlsm extension. Check the Recycle Bin and any version history for OneDrive or a managed team location. A missing saved file is a different task from finding edits that were never written to disk. The unsaved Excel recovery article goes deeper into the crash path.
Find the configured AutoRecover folder
In desktop Excel for Windows, open File > Options > Save and read the AutoRecover file location shown there. Copy that path into File Explorer’s address bar rather than typing a guessed path from an old tutorial. This setting can differ by Office version, Windows account, organization policy, or a change made by the user. Check whether Save AutoRecover information is enabled and note its interval. The interval is not a promise that every recent keystroke was captured.
Open the folder without moving or deleting anything. Sort by date modified and look for files created around the time of the crash. Copy likely candidates to a separate folder before trying them. Open a copy through Excel’s File > Open, not by repeatedly renaming an unknown original. If Excel offers a repair prompt, work on the copied candidate. A successful open is only the first test: inspect the relevant sheets, formulas, and latest entries.
AutoRecover is an emergency copy, not a versioned backup of every edit. It may not contain a workbook that was open too briefly, or the final moments before power was lost. A setting can be disabled for a particular workbook. Different Office editions display the controls somewhat differently, so follow the labels visible in your version rather than a hard-coded folder printed on another PC.
Know what a temporary workbook is and is not
While a saved workbook is open, Excel or Windows may create temporary working files in or near the workbook’s folder. Some names begin with symbols or look unrelated to the file title. These files can support locking, saving, or a temporary handoff. They are not automatically complete backups. If you find one, preserve a copy, record its size and date, and avoid deleting the original workbook to make the temp file appear more useful.
A tiny lock or owner file cannot restore a large workbook. A zero-byte file has no spreadsheet content to read. Even a substantial file with a plausible date still needs to open in Excel and contain the expected sheets. File extension alone does not establish what is inside. If a candidate has no recognizable spreadsheet structure, repeated renaming from .tmp to .xlsx will not reconstruct missing cells. Stop and check a different recovery source.
Windows’ general temporary folders can contain many unrelated files from browsers, installers, and other programs. Searching them by date may occasionally reveal a relevant candidate, but do it after Excel’s own recovery options and the original folder. Do not run a cleanup utility or empty the temp folder while investigating. Those actions can remove the remaining candidate. If your issue is that Excel cannot save a current workbook, the Excel save-problem guide addresses permissions and location rather than missing recovery copies.
Open a candidate safely and judge its value
Make a copy of each promising file to a healthy location and label it with its original path and time. In Excel, open the copy through File > Open. If Excel displays a warning, do not enable macros merely to see whether the file works. Compare the workbook name, sheet tabs, key formulas, and the last rows you edited. A copy that opens but lacks the latest sheet is not a complete recovery. Save verified candidates under distinct names so that you can return to an older version if needed.
If the workbook is stored in OneDrive or SharePoint, inspect its version history before relying on a local temporary file. Version history can contain a meaningful earlier save that a temp-folder search cannot show. Compare dates carefully and download or save a separate copy before choosing a restore action that might replace the current cloud version. A workbook that belongs to another Microsoft account may not show under your signed-in account.
If a workbook opens with damaged content, work only on a copy. Excel’s Open and Repair option may extract some content, but repair can also change the file. Check the copy’s sheet count, formulas, charts, and linked data afterward. The workbook recovery overview covers broader saved-file cases. None of these routes can recreate changes that existed only in memory and were never saved or captured by AutoRecover.
When the saved workbook itself was deleted
Drecov is Windows data-recovery software for files that were saved and then deleted, lost, or made inaccessible on a stable, recognized device. Here its role is to search the original local drive for an actual workbook file, not to extract an individual worksheet from a still-open workbook or retrieve edits that never reached storage. The Drecov recovery overview explains its Quick Scan, Deep Scan, filtering or locating, previews for supported results, and recovery to a different healthy destination. Lost Partition Recovery can help locate files after a partition disappears; that does not mean it repairs Excel’s temporary-file mechanism.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Check the Recycle Bin, File History if enabled, and any cloud version history first. If the saved file is still missing, stop saving new work to the drive where it lived. New writes can overwrite deleted data; on an SSD, TRIM can further reduce recovery chances. Prepare a healthy external disk or other separate destination. Do not install recovery software onto the source partition. If the source drive clicks, drops offline, or reports severe read errors, stop scanning it and consider a professional image or recovery service instead.
Step 1: Open Drecov and select the former workbook location
Open Drecov from a working Windows environment. Choose the original drive or partition that held the deleted .xlsx or .xlsm file. If the file was on a USB drive, select that stable device rather than the PC’s system disk. If it existed only in a cloud account and no local copy was ever saved, use the cloud’s history and trash instead of scanning an unrelated local drive.
Step 2: Start with Quick Scan
Run Quick Scan on the original location. Look for the workbook’s former folder and name. If a relevant result appears, keep searching for additional versions before recovering, because the newest-looking file may be incomplete. Do not save any scan output onto the source drive.
Step 3: Deep Scan and inspect likely workbooks
If Quick Scan does not find the target and the device remains stable, run Deep Scan. Narrow the result list by file type, path, date, or name where available. Preview a representative supported file before selecting a group. A preview may show that some content can be read, but it cannot certify every formula, macro, pivot table, or external link in the workbook.
Step 4: Recover to another drive and verify in Excel
Recover chosen workbook candidates to the prepared healthy destination, never back to the source. If the files are not in the folder you expected, check Drecov Folder or Recovery Folder on that destination. Open each candidate in Excel, review the needed sheets and formulas, and compare its contents with any AutoRecover or cloud copy. Only after verifying a usable workbook should you consider cleanup, repair, or another action that writes to the original drive.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Keep future recovery simple
After you have secured the best available version, choose a routine that fits how you work. Save important workbooks with a clear file name and location. Check File > Options > Save to confirm AutoRecover is enabled at a sensible interval, but continue using Save regularly. If the file lives in a supported cloud location, confirm you are signed into the intended account and that syncing has finished. AutoRecover, cloud history, and an independent backup protect against different failures.
For a critical workbook, test the backup rather than assuming a copied filename means usable content. Open the backup copy, inspect a recent entry, and confirm that linked sheets or macros you rely on behave as expected. Store the backup on a separate device or service. A second copy on the same failing disk is not much protection against a hardware problem.
If you work with sensitive spreadsheets, avoid uploading unknown temporary files to random online converters. A legitimate recovery candidate may contain private data, even when its name looks meaningless. Use Excel’s local recovery functions first. Seek organizational IT help when the workbook is managed by your employer or protected by a corporate account.
Conclusion
The location of Excel temp files depends on the kind of copy you need. Start with Excel’s recovery pane and Recover Unsaved Workbooks, then inspect the configured AutoRecover folder and the original file location. Judge each candidate by opening a copy and checking real workbook content, not by its extension alone. If a previously saved local workbook was actually deleted, Drecov can search the stable source drive and recover candidates to another device. It cannot restore edits that were never saved or captured. Keep the best verified copy before you clean up or repair anything.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
