A situation that is familiar to many office workers—there is an hour left before the report. You are a little worried, although there are no special reasons for concern because everything has already been double-checked. Suddenly, instead of slender columns and graphs, this inscription pops up:
While you are trying to open this Excel file for the hundredth time, the situation in the office is changing. Attention is focused only on you. Someone looks with sympathy, mentally wishing good luck, and someone grins maliciously, anticipating the imminent dismissal of a colleague. What to do?
No panic! There is a reliable way to fix a damaged document. It is a Recovery Toolbox For Excel application https://excel.recoverytoolbox.com/. But before downloading it, I advise you to try the usual methods for recovering Excel files. In any case, you have nothing to lose.
How To Protect Documents On A Disk
No Excel document is insured against damage, no matter xls, and xlsx. If you have not encountered this, it means that you merely did not work with tables and graphs quite actively. Most problems can be avoided. You only need to set up a backup in advance:
- Open the Excel document
- File – Save as
- Go to the Overview—square button
- Click on the Service button
- Go to the General Settings section
- Check the box next to Always keep a backup.
In just a minute, you will always have a backup of the critical file, but do not forget to drop documents from your flash drive from time to time. Only removable media can protect against any computer problems. It is also worth checking the autosave settings. Be sure to make sure that the MS Excel settings match the picture below.
Now you know how to protect your work from PC crashes. But what if the document is no longer available? First, check its size. Right-click on the document—Properties – Size. When the file size is from a few hundred kilobytes, and preferably several megabytes, the file can be restored, and if the book has shrunk to a couple of tens of kilobytes or less, the information is lost forever.
Standard MS Excel Tools
The data on the disk was saved; it remains to extract them from the damaged book. Not everyone knows that MS Excel has its own recovery tools. Usually, they work automatically, but sometimes the debugged mechanism fails. Therefore, you need to go into Excel settings and run the built-in tool manually:
- Go to File – Open
- Select Open Document
- Find the file you need in the popup window
- Click on the arrow next to Open
Click on Open and Restore
Unfortunately, this built-in recovery feature rarely works. If the file cannot be fixed, instead of the Restore command, press the adjacent key. It is called Extract data. This option will at least return data from lost tables. If it fails again, then move on.
There is a little trick. Sometimes you can open a damaged Excel document with it. Before starting the file, the system recounts the formulas in the document each time. This function, which in this case prevents the file from being opened, can be disabled. Nothing complicated.
First, create an empty document and open it. Further File – Parameters. Go to the Formulas tab—on the left side of the page. Here you need to select the command Calculations in the book manually. Then, without closing the active workbook, try to open the document you need through File – Open.
Didn’t work out? It’s okay. From the very beginning, the chances were low, but it was still worth a try. We turn to professional tools for working with Excel.
Repair Damaged Files Online
Your trump card – service for recovering damaged documents Online File Repair Service https://excel.recoverytoolbox.com/online/. Ideal for business people who do not want to lose valuable time. You can find similar services on the network, but the Online File Repair Service has been a leader in its segment for many years, and this is unlikely to change soon. Particularly attractive is the cost, which is the lowest among the competitors.
The principle of operation is easy to understand. Just follow the link https://excel.recoverytoolbox.com/online/ and follow the instructions of the developers. In the process, you will be required to provide an email address—a corrected document will be sent to it—upload the file and start recovery.
The online service allows you to familiarize yourself with the results in advance, so you will not need to pay if restoration is not possible. The average price is ten dollars for one uploaded file. After payment, you will immediately receive a restored document, and you can open the champagne and start celebrating!
Recovery Toolbox For Excel Is The Ultimate Solution
Suppose you have not one damaged document, but several or the data in the tables constitute a trade secret, which under no circumstances can be passed on to outsiders. Then I recommend taking a look at Recovery Toolbox for Excel https://excel.recoverytoolbox.com/.
The tool is a powerful one to repair damaged Excel files. The program is already 15 years old. It is growing along with Microsoft products. Most importantly, there is a free trial version, so you don’t have to buy a pig in a poke.
Be sure to test Recovery Toolbox for Excel before purchasing. If there are no problems during processing, you only have to buy a license. After that, you can upload and save documents in any quantity. You will also get access to support and regular updates.
On this note, I say goodbye. Remember to back up important files.