Unsolved
This post is more than 5 years old
1 Message
0
984
April 27th, 2018 12:00
How to fix the format?
My Excel program began to behave strangely after the system virus was penetrated into the software of my PC, which is now found and neutralized by the antivirus. After some time, Excel when editing files began to often give errors about the wrong format and data corruption, which led to distortion of information in some files. For example, instead of calculations, meaningless symbols began to appear and the format changed. The Excel update partially solved the problem with the errors that were generated in the newly created files. But there were incorrect files that I have no idea how to fix the formatting in them. How to be?
No Events found!
SebastianRoberts
1 Message
0
April 30th, 2018 13:00
Here are top 5 recommended methods that help you to recover data from corrupt MS Excel file:
1: Try to repair xlsx file it manually when MS Excel does not automatically starts File recovery mode.
Click the Microsoft Office Button, and then click Open.
Now select the corrupted workbook that you want to open.
Click the arrow next to the Open button, and then click Open and Repair.
Choose either Repair (to recover as much of the file data) or Extract data (to extract values and formula when repair process is not successful).
2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & save Microsoft Excel files.
3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.
4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.
5: Try 3rd party software