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.
Ce guide explique 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.
Prise en charge de Windows 7/8/10/11 et Windows Server
Table des matières
Choose the Right Method to Recover Excel Files
First, match the problem with the right method.
Problème | Best method |
Excel crashed before saving | Document Recovery or Excel AutoRecover |
Vous avez fermé Excel sans l'enregistrer | Récupérer des classeurs non sauvegardés |
You deleted the workbook | Corbeille ou Trash |
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 | Ouvrir et réparer |
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:
- Ouvrir Excel.
- Cliquez sur Fichier > Info.
- Sélectionnez Gérer le classeur.
- Click Recover Unsaved Workbooks.
- Choose the file you need.
- Ouvrez-le et enregistrez-le immédiatement.
Cette méthode vous aide à récupérer un fichier Excel non enregistré 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\%LocalAppData%\Microsoft\Office\UnsavedFiles%temp%
Also search for .xlsx, .xls, .xlsm, .tmp, et ~$. 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
Si vous deleted an Excel file normally, check Recycle Bin first. Search by file name or .xlsx, right-click the workbook, and choose Restore. This can récupérer un fichier Excel supprimé data quickly.
However, Recycle Bin cannot help after Shift + Delete, Vider la corbeille, 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.
Procédez comme suit :
- Ouvrir Explorateur de fichiers and go to the folder where the overwritten Excel file was originally saved.
- Right-click the folder that contains the Excel workbook, then choose Propriétés.
- In the Properties window, click the Versions précédentes tabulation.
- Windows will show a list of available earlier versions of this folder. Select a version created before the Excel file was overwritten.
- Cliquez sur Ouvrir 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 Restaurer 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.
- Ouvrir Excel.
- Go to File > Open > Browse.
- Sélectionnez le classeur endommagé.
- Click the arrow next to Open.
- Choisissez Ouvrir et réparer.
- 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 supprimé définitivement, 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 perte de données. 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 fichiers non enregistrés. By contrast, Magic Data Recovery scans the storage location itself.
Comment utiliser Magic Data Recovery
Suivez les étapes suivantes pour récupérer des fichiers Excel with Magic Data Recovery.
Étape 1 : Télécharger et installer 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.
Prise en charge de Windows 7/8/10/11 et Windows Server
Étape 2 : Sélectionner le lecteur à analyser
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, ou .xlsm workbook appears in the results.
Étape 4 : Prévisualisation des fichiers Excel avant la récupération
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.
Étape 5 : Récupérer les fichiers Excel dans un emplacement sûr
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
Une fois que vous avez compris 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.
Conclusion
La meilleure réponse à 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 Récupération d'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.
Prise en charge de Windows 7/8/10/11 et Windows Server
FAQ
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.
Où sont stockés les fichiers temporaires d'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.
