Cannot open xlsm file. the file format is invalid error on opening and saving

Backups are important, but if you back up a corrupt file, depending on the type of backup system you use, you can only recover the corrupt version.

https://www.excelforum.com/tips-and-...ml#post5613970

Here is an application that allows you to keep multiple versions of the same file. Typically, I save the last 5 versions of a file, but you can save as many versions as you are willing to create backup files for.

This is not likely to be a virus. If you are attempting to recover an already corrupt file, I have no suggestions other than a long shot.

Excel files are actually a collection of XML files. Take the Excel file and remove the XLSX (or whatever) extension. Then add a .ZIP extension and try opening it. If this works, then you will see a collection of files and folders. Save .ZIP file, preferably under a different name. Then restore the original file extension and try to open it.

Hi Rajuj,

An Excel file gets corrupted due to various reasons such as a virus/malware attack, sudden system shutdown when the Excel file is still open, power failure while working with an Excel spreadsheet, etc.

As your excel file is a macro-enabled .xlsm file, I suggest you try the following workarounds-

1. Set the Calculation Option in Excel to Manual-

Go to File > New.

Click on Blank workbook under the Available Templates tab.

Then Go to File > Options.

The Excel Options window is displayed, Click the Formulas option.

Go to the Workbook Calculation section and click on the Manual option.

Click on OK.

Click on the Open tab in the File menu.

Choose the desired corrupted workbook and then click on Open.

2. Open and Repair-

I think you have already done this.

If none of these work for you, I suggest you use a professional excel recovery tool that gives you the accessibility to preview your data like Stellar does.


Best Regards.