Have you ever accidentally deleted an important Excel file or saved over important data? Don’t worry, there are ways to recover your lost files and undo your mistakes. In this article, we will show you how to recover deleted or overwritten Excel files.
Cara Mengembalikan Data Excel Yang Tertimpa
Sometimes you may accidentally overwrite an important excel file and lose all the data you have inputted. To recover overwritten data we can use Microsoft Excel’s built-in feature called ‘Version Control’.
- Open the Excel file that was overwritten.
- Click on the ‘File’ tab and select ‘Info’.
- Click on the ‘Manage Workbook’ drop-down menu and select ‘Version History’.
- A panel will appear on the right-hand side of the screen showing all the available versions of the Excel file. Select the version you want to restore.
- Click ‘Restore’ to recover the selected version of the Excel file.
If you don’t see the Version Control option in Excel, it’s probably because you’re not using an Office 365 subscription. In this case, you can try a third-party data recovery tool.
Cara Mengembalikan Dokumen Excel Yang Belum Tersimpan
Have you ever spent hours working on an Excel file only to accidentally close it without saving? Fear not, there is a way to retrieve your unsaved Excel files.
- Open Excel and click ‘File’.
- On the left-hand menu, click ‘Info’.
- On the right-hand side of the screen, click ‘Manage Workbook’ and select ‘Recover Unsaved Workbooks’.
- Excel will then open a folder containing all unsaved files. Look for the file you were working on and open it.
- Save the file as usual to prevent losing it again.
You can also enable Excel’s AutoRecover feature to automatically save a copy of your work every few minutes, which can be found in Excel Options under the Save tab.
FAQ
1. How do I recover a permanently deleted Excel file?
If the file was permanently deleted and can’t be found in the Recycle Bin, you may have to use a third-party data recovery tool. There are a number of free and paid options available online such as Recuva, EaseUS, and Disk Drill.
2. Can I recover an Excel file if it’s been damaged or corrupted?
If an Excel file is damaged or corrupted, you may be able to recover it using Excel’s built-in recovery options. Go to ‘File’ > ‘Open’ and browse for the corrupt file. Click the arrow next to ‘Open’ and select ‘Open and Repair’. If that doesn’t work, you may have to try a third-party recovery tool.
Hopefully, these tips will help you recover your lost Excel files and undo your mistakes. Always remember to save your work regularly and enable AutoRecover to prevent losing your data. If all else fails, a third-party data recovery tool may be your best bet.