Excel 365 corrupting files with macros

[Holly_PowerExcelUser]

I have a relatively simple excel file that contains some macros to do some text manipulation. It was working 1 month ago.  I updated my office 356 to the current year. Now, it opens, but no modules can be displayed or exported.  I have repaired office, uninstalled it, re installed it and re-repaired it.  I've gone back to backups of the file. Repairing it remove ALL FORMULAS and ALL MODULES. So, "repair" isn't really a repair. The errors reported (that corrupted an entire file) is two lines saying there was a problem in a formula on one of the sheets.  "Details" restates that exact text in XML, so clearly not any form of "detail".  I am a power user having used Excel and VBA for decades.  Does anyone have a solution? Does Microsoft even care?

[#2]

@Holly_PowerExcelUser 

Excel 365 corrupting files with macros is an ongoing issue that has been reported by some users. However, there is currently no ETA "Estimated Time of Arrival" for a solution.

In the meantime, there are a few things you can try to recover your corrupted file:

• Open and repair the file. This may fix the corruption and allow you to open the file without losing any data.
• Save the file as an older format. This may work if the corruption is related to the newer file format.
• Use a third-party file recovery tool. There are a number of third-party tools that can help you recover corrupted files.

Here a workaround that you can try in the meantime.

Here are the steps on how to use the workaround:

    Open the corrupted workbook.

    Disable macros.

    Save the workbook as a .zip file.

    Open the .zip file, and then open the workbook.

    Enable macros.

This workaround may not work for all workbooks, but it is worth trying.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.