the terror of many users and employees. The report is missing an hour, there is tension even though there should be no reason to be worried since the files have been checked several times. Suddenly, however, this writing appears instead of columns and graphs.
Trying to open the Excel file does not change the situation, and in these cases it is better not to panic. So what to do? There are several attempts that can be made in these circumstances and below we propose one that proves in many circumstances more than reliable for fix a damaged Excel document. The application that will be used in this attempt Recovery Toolbox for Excel (here the link to the official website), but first you can try the classic method.
How to protect documents on disk
No Excel document protected against damage, no matter if .xls or .xlsx, and data corruption can always be around the corner especially for those who often work with graphs and tables. Most problems, however, can be avoided protecting the document a priori through a backup copy. In more recent versions of Excel the automatic saving is usually active by default.
But it may not be enough. Another very important practice for the protection of your documents (Excel, but also on other formats) saving the file also on a removable drive. This allows you to circumvent any critical problem on your computer that leads to damage to the storage units. It is also worth checking the autosave settings, such as shown in the photo below.
But what if the document is already lost? Obviously the precautionary procedures do not work in this case, but the hopes are not lost. First, let's check the file size with the right mouse button on the document, properties and then check the dimensions. When the file size of a few hundred KB, or rather several MB, the file can be restored. But if instead the size of a few KB is reported, the information lost forever and useless to try to restore.
MS Excel recovery tools
In the first case, the data may be inaccessible but still present, and only a find remains effective method for extraction. Excel has its own integrated recovery tool which is usually put into operation automatically when necessary. If this does not happen, you can force the opening by starting the integrated tool manually by selecting the item Open and restore while trying to open the damaged file. Unfortunately the integrated function is not always effective.
If the file can not be fixed, instead of the command Restore, you can try it with the function Extract data, which is used to get back the data in the file. But even in this case effectiveness in 100% of cases is not guaranteed. There is a little trick to improve its effectiveness: before starting the file, the system recalculates the formulas in the document every time, a function that – in the case of damaged files – could prevent the file from opening. It can be deactivated through the Calculation options, which should be set to Manual.
If the integrated Excel systems have not worked, you can try using specific third party systems, such as Recovery Toolbox or the service Online File Repair Service.
Repair damaged Excel files online
Online File Repair Service a specific system for repairing damaged Excel files and can be found at this address. Ideal for professionals who don't want to waste precious time, Online File Repair Service it is offered at an average competitive price of approximately $ 10 for a file.
The operation of the service is extremely simple to understand, also thanks to the step-by-step procedure present. At the end of the operation, the correct file will be sent to an e-mail address, after the user has obtained a preview which serves to show the success of the operation. The user, or the professional, will pay only after making sure that the file is recoverable. So how do you do it?
Just direct your browser to the site https://excel.recoverytoolbox.com/online/it/ and follow the instructions that appear on the screen. In the process you will need to enter an email address where the correct file will be sent, upload the file and start recovery. After verifying that the recoverable file will be possible to make the payment and quickly receive the restored document.
What about sensitive files? In this case it would be better not to send data to remote servers, and it can come to the rescueRecovery Toolbox for Excel, application that can be downloaded at this address. The useful tool to repair damaged Excel files and also available in a free trial version that can be used before purchase. The license can be purchased only after verifying the effectiveness and guaranteeing the restoration of the files for life, without any limitation in use.
