Microsoft Excel made it easy to enter, track, and consolidate data for personal, professional, and business use. Unlike other similar programs, this one gives you better assurance at recovering lost or accidentally-deleted files. If you are editing a spreadsheet and your computer suddenly freezes, you might end up with a problematic or missing Excel file. When retrieving files, you have to do it as soon as possible, but make sure you don’t do it carelessly.
Below are the things you need to know when locating Excel Files on a Mac PC.
The AutoRecovery function may or may not work in your favor.
The AutoRecovery function is a notable feature of Microsoft Office. However, it may not work on your current dilemma if you fail to enable the said function in Microsoft Excel. Enabling this feature on other Microsoft programs such as Word and PowerPoint doesn’t automatically mean that it is also enabled in Excel. It must be enabled individually.
With this function, you can look for your auto-saved files in no time. However, the recovered files may not open once you click them. Instead of opening the files right after you see them on the AutoRecovery folder, transfer them first to your desktop or on any other folder. You can open them afterwards.
In case of a crash, it is best to wait for 15 to 30 minutes before restarting your computer.
Crashes tend to happen a lot in some Mac computers. While it is advisable to recover your files as fast as you can, you have to wait for at least 15 minutes before restarting your PC. If you restart it right away, your computer may launch a disk check which might make it harder for you to recover your files.
The files you are trying to retrieve should be saved at least once.
Before entering data in a new Excel spreadsheet, make it a habit to save the file right after creating it. The AutoRecovery function of Microsoft only works if you manage to save your file at least once. If you fail to do so, there is no chance for you to recover the files.
Avoid adding new files to the drive where your Excel files were previously saved.
When saving files, avoid giving them generic names. If one of your Excel spreadsheets went missing and you created a new one with a similar name, the AutoRecovery function of Excel may only auto-save the changes in the latest file.
Install data recovery software in a drive that’s different from the one where you saved your Excel files.
A data recovery program can help you find your missing files more efficiently than by doing it all on your own. However, when installing such software, connect an external drive, flash drive, or memory card where you can save it. Don’t save and install it in the same drive as the one you used for your Excel files. Its data recovery process involves scanning the drive where the files were saved. It may not work effectively if the software is located in the drive that it scans.
When using a data recovery tool, simplify your search by specifying the type of file you want to retrieve.
A data recovery tool can retrieve over a hundred of file types. Upon scanning your drive, it may feature a hundred or even a thousand of different folders and files. To streamline your search, you can just specify the type/s of file you want to recover. In the case of Microsoft Excel files, you can modify your search by focusing on files with .xlsx or .xls extensions.