How to Recover Files in Excel Without Losing Data
Losing an Excel workbook can stop your work in seconds. A report may vanish after a crash, deletion, or accidental overwrite. Therefore, how to recover files in Excel depends on what happened before the file went missing.
このガイドでは how to recover files in Excel for unsaved, deleted, overwritten, corrupted, and lost workbooks. You will use Excel AutoRecover, Excel temporary files, Recycle Bin, Version History, cloud backups, and Magic Data Recovery. Also, you will know when Excel file recovery software gives you a better next step.
Windows 7/8/10/11およびWindows Serverをサポート
目次
Choose the Right Method to Recover Excel Files
First, match the problem with the right method.
問題 | Best method |
Excel crashed before saving | Document Recovery or Excel AutoRecover |
保存せずにエクセルを閉じた | 保存されていないワークブックを復元する |
You deleted the workbook | ごみ箱またはゴミ箱 |
Recycle Bin is empty | Magic Data Recovery |
You saved the wrong version | Version History or Previous Versions |
The file disappeared from USB, SD card, HDD, or SSD | Magic Data Recovery |
The workbook opens blank or corrupted | オープンと修理 |
The file was synced online | Cloud Version History |
This checklist makes how to recover files in Excel easier and safer.
Method 1: Recover Files in Excel After a Crash or Unsaved Close
If Excel crashed, froze, or closed during a power failure, start with the Document Recovery pane. Reopen Excel, open the newest recovered version, and save it with a new name.
If the pane does not appear, try Recover Unsaved Workbooks:
- エクセルを開く。.
- ファイル＞情報をクリックする。.
- ワークブックの管理」を選択します。.
- Click Recover Unsaved Workbooks.
- Choose the file you need.
- 開いてすぐに保存する。.
この方法は、次のような場合に役立ちます 保存されていないExcelファイルを復元する content when Excel kept a recent temporary copy. However, it may fail if Excel cleared that copy. Next, check AutoRecover and temporary file locations.
Method 2: Recover Excel Files with AutoRecover and Temporary Files
Excel AutoRecover saves recovery information at regular intervals. It does not replace manual saving, yet it can help after crashes and system errors. To check it, open File > Options > Save, confirm that AutoRecover is on, and review the file location.
Next, search these Windows folders:
%AppData%\Microsoft\Excel\UnsavedFiles%emp%
Also search for .xlsx, .xls, .xlsm, .tmp, そして ~$. When checking Excel temporary files, sort results by date modified. Temporary files often use unusual names, so the date, size, and extension can help. After you find a possible file, open it and save a new copy.
Method 3: Recover Excel Files After Deletion or Overwriting
もしそうなら deleted an Excel file normally, check Recycle Bin first. Search by file name or .xlsx, right-click the workbook, and choose Restore. This can 削除されたExcelファイルの復元 data quickly.
However, Recycle Bin cannot help after Shift + Delete, ごみ箱を空にする, formatting, or storage device errors. In those cases, stop using the affected drive and scan it with recovery software.
If you saved over an Excel workbook by mistake, you can try restoring it from Previous Versions on Windows. This feature may contain earlier copies of your files created by File History, restore points, or backup settings.
以下の手順に従ってください：
- オープン ファイルエクスプローラー and go to the folder where the overwritten Excel file was originally saved.
- Right-click the folder that contains the Excel workbook, then choose プロパティ.
- In the Properties window, click the 旧バージョン タブ.
- Windows will show a list of available earlier versions of this folder. Select a version created before the Excel file was overwritten.
- クリック オープン first to check whether the older Excel file is inside that folder version.
- If you find the correct workbook, copy it to another safe location, such as the Desktop or an external drive.
- If you are sure this is the version you need, you can also click リストア to restore the folder to that earlier state. Be careful, because restoring the whole folder may replace newer files in that folder.
- Open the recovered Excel workbook and check whether the data is complete.
If no previous versions are listed, it usually means File History, System Protection, or backup settings were not enabled before the file was overwritten. In that case, try OneDrive or SharePoint Version History if the file was synced online, or use professional file recovery software to scan the drive.
Method 4: Recover Excel Files When the Workbook Is Corrupted
Sometimes the workbook still exists, yet it opens blank, shows an error, or says the format is invalid. In this case, try Excel’s Open and Repair tool.
- エクセルを開く。.
- Go to File > Open > Browse.
- 破損したワークブックを選択します。.
- Click the arrow next to Open.
- 開くと修復を選択します。.
- Try Repair first, then Extract Data.
This method may recover values and formulas. However, it may not restore every chart, macro, or format. Therefore, save the repaired workbook as a new copy and keep the original unchanged.
Method 5: Recover Files from Cloud Storage
Many Excel workbooks sit in OneDrive, SharePoint, Google Drive, Dropbox, or iCloud. If your file disappeared after syncing or collaboration, check the cloud recycle bin, Version History, shared folders, recent files, offline sync folders, and email attachments.
Cloud recovery works well for shared workbooks. However, it will not help if the workbook only existed on a local drive, USB drive, SD card, HDD, or SSD. In that case, Magic Data Recovery may fit better.
Method 6: How to Recover Excel Files with Magic Data Recovery
When Excel’s built-in options cannot locate your workbook, Magic Data Recovery can scan the affected drive. This method helps when a workbook was 永久削除, removed from Recycle Bin, lost after formatting, or missing from a storage device.
Magic Data Recovery works as Excel file recovery software for more serious データ損失. It scans storage locations directly, lists recoverable files during the scan, and lets you preview files before recovery. Therefore, you can focus on the workbook you need.
Use Magic Data Recovery when your Excel file is not in Recycle Bin, you deleted it permanently, it disappeared from a USB drive or SD card, a drive was formatted by mistake, Excel AutoRecover shows nothing, or Windows search cannot locate it.
Compared with manual methods, Magic Data Recovery covers harder cases. Recycle Bin handles normal deletion. Version History needs backups or cloud sync. AutoRecover mainly helps with crashes and 未保存ファイル. By contrast, Magic Data Recovery scans the storage location itself.
Magic Data Recoveryの使い方
以下の手順に従ってください。 エクセルファイルの復元 with Magic Data Recovery.
ステップ1: Magic Data Recoveryのダウンロードとインストール
First, download Magic Data Recovery and install it on a drive different from the one where your Excel file was lost. This step matters because installing new software on the affected drive may overwrite recoverable Excel data.
Windows 7/8/10/11およびWindows Serverをサポート
ステップ2：スキャンするドライブを選択する
Launch Magic Data Recovery. Then, from the main interface, choose the drive or partition where your Excel workbook was deleted, lost, or previously saved. After that, start the scan.
Step 3: Scan the Drive for Lost Excel Files
The software starts scanning the selected drive. Meanwhile, it lists recoverable files as it finds them, so you can check whether your missing .xlsx, .xls, あるいは .xlsm workbook appears in the results.
ステップ4：リカバリ前にExcelファイルをプレビューする
Next, use the preview function to check file content before recovery. This step helps you confirm that you found the correct workbook instead of restoring unnecessary, outdated, or duplicate files.
ステップ5：Excelファイルを安全な場所に復元する
Finally, select the Excel files you want to recover and save them to a different drive or secure folder. Do not restore recovered files to the same location where they were lost, because doing so may overwrite other recoverable data or cause file corruption.
Best Tips After You Recover Lost Excel Files
一度理解すれば how to recover files in Excel, reduce future risk. Turn on AutoSave, keep Excel AutoRecover enabled, shorten the AutoRecover interval, and back up key workbooks to both cloud storage and another local drive.
Also, avoid editing important files directly from unstable USB drives, save major updates as separate versions, and test your backups occasionally because a backup only helps when you can restore it.
まとめ
に対する最良の答え how to recover files in Excel depends on the problem. For crashes, start with Document Recovery and AutoRecover. For unsaved workbooks, try Recover Unsaved Workbooks. For deleted files, check Recycle Bin. For overwritten workbooks, use Version History or Previous Versions.
However, built-in tools cannot solve every case. When a workbook is permanently deleted, missing from Recycle Bin, lost after formatting, or unavailable through cloud backups, Magic Data Recovery gives you a stronger recovery path. It scans the affected drive, helps locate recoverable Excel files, supports preview before recovery, and guides users through a simple process.
For that reason, Magic Data Recovery is a practical choice when standard エクセルの回復 methods fail. If you still wonder how to recover files in Excel after trying manual fixes, this tool can help you continue with less guesswork.
Windows 7/8/10/11およびWindows Serverをサポート
よくある質問
Can I recover an Excel file I did not save?
Yes. Open Excel and go to File > Info > Manage Workbook > Recover Unsaved Workbooks. Also, check Excel AutoRecover and the UnsavedFiles folder. However, this only works when Excel kept a temporary copy, so save the recovered workbook immediately in a safe folder.
How do I recover a deleted Excel file?
First, open Recycle Bin and search for the file name or .xlsx. If you find it, restore it. However, if Recycle Bin is empty, use backup tools, cloud history, or Magic Data Recovery to recover deleted Excel file data from the affected drive.
Can I recover an overwritten Excel file?
Yes, if an older version exists. Check Version History in OneDrive or SharePoint first. Next, try Windows Previous Versions if File History or restore points are available. If neither option works, stop editing the file and scan the storage location.
Excelの一時ファイルはどこに保存されますか？
Excel may store temporary files in %AppData%\Microsoft\Excel\, %LocalAppData%\Microsoft\Office\UnsavedFiles, or %temp%. Because Excel temporary files may use unusual names, search for .xlsx, .xls, .xlsm, .tmp, and ~$, then sort by date modified to find recent workbook copies.
Can Magic Data Recovery recover Excel files from a USB drive?
Yes. Magic Data Recovery can scan a USB drive and help recover Excel files that disappeared after deletion, formatting, or device errors. For better results, stop using the USB drive first. Then, scan it and save recovered workbooks to another safe location.
Why does my recovered Excel file open blank?
A recovered workbook may open blank because corruption or partial overwriting damaged the file. First, try Open and Repair in Excel. Then, check previous versions or scan again. Also, keep the original recovered file unchanged so you can try another recovery method.
