Corrupt file

Here are a few suggestions obtained from the Net:

RESTORE CORRUPT FILE

Restoring a Corrupted File
This is the reply from one of members re restoring a corrupted file

The techs at Microsoft were able to restore the Excel file!

I'm not sure what all they did (some of it was magic, evidently), but here's a tip they passed along.

If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls

They say that will often recover lost information, or restore a corrupt file.
=================================================================================

http://directory.s2services.com/excel.htm
=================================================================================

https://support.office.com/en-us/art...A-801DDCD4EA53
=================================================================================

Another way of restoring broken/corrupted Excel files
I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy anything was salvaged at all :-)

Thank you. Downloaded OpenOffice and opened in there which worked. Then saved back into excel format and reopend in Excel with success.

Thanks again
Karl

Wonderful !

Certainly beats having to re-type all those lines of code.

Cheers.

Thanks for the Rep and those who responded privately.

Good to know I can still do something right this week ! Been a bad run so far .....

Originally Posted by karl-eQ

Thank you. Downloaded OpenOffice and opened in there which worked. Then saved back into excel format and reopend in Excel with success.

Thanks again
Karl

Worked for me too.Thanks karl-eQ

To repair corrupt Excel file, you can try following solutions:

1. Open and Repair - Open MS Excel and Select the corrupt file. Click on Open and Repair option and follow the instructions.

2. Delete COM Add-Ins - Under Add-Ins section, try to delete COM Add-ins and then try to open your file.

3. If you can't open the file then Set the calculation option to manual. Click File > Options. In the Formulas category, under Calculation options, pick Manual, and then click OK

You can also check this blog on Experts Exchange: https://www.experts-exchange.com/art...corrupted.html

Hi,

I am glad to assist you.

There are possible causes for this error.

If you’re using an unsupported Excel file format or maybe the file is corrupted due to sudden power off. And when opening an older version of the excel file in a new version on MS Office, this error may occur.
And here are the solutions you can use to solve the error:

Solution 1: Change the default file format.

• Try changing the Excel default file format by following these steps:
• In Excel 2010 and newer versions, click on the File menu.
• In the Info screen that appears, click on Options.
• In the ‘Excel Options’ window, under the Save workbooks section, click on the Save files in this file format: drop-down. Select a file format (i.e., the one supported by your Excel version).
• Click OK.

Check if you can open your Excel file. If not, try the next solution.

Solution 2: Edit the excel file permissions
Follow these steps to change the file permissions and see if it fixes the problem:

• Right-click on the file that won’t open and click Properties.
• In the file properties dialog box, click the Security tab and then hit the Edit button.
• When the file’s permissions dialog box appears, click on the Add button.
• Click on the Advanced button from the ‘Select Users or Groups’ window.
• Select Find Now. A list of all users and groups will get displayed in a search results box. Choose Everyone group from the list and hit OK.
• You can see the ‘Everyone’ group in the ‘Enter the object names to select’ textbox. Click OK once again to return to the file’s permission dialog box.
• Click Everyone from the Group or user names: box and check all the checkboxes under Allow.
• Click on Apply and then OK.

Now try to open the Excel file.

I hope this will help.

Thanks,
Alice