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 |
저장하지 않고 Excel을 닫은 경우 | 저장되지 않은 통합 문서 복구 |
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:
- Excel을 엽니다.
- 파일 > 정보를 클릭합니다.
- 통합 문서 관리를 선택합니다.
- Click Recover Unsaved Workbooks.
- Choose the file you need.
- 파일을 열고 즉시 저장하세요.
이 방법은 여러분이 저장되지 않은 엑셀 파일 복구하기 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\%로컬앱데이터%\소프트웨어\오피스\저장되지 않은 파일%temp%
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.
- Excel을 엽니다.
- 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 사용 방법
다음 단계를 따르세요. Excel 파일 복구 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 Excel 복구 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.
