Error in Excel 2007: "Excel has found unreadable content in this file ..."
Posted on 2011-10-28
I have a real problem here. I create weekly reports with a macro in Excel 2007 that saves the files as an XLSM file. Initially it re-opens fine. But if I make any changes to it and re-save, then when I open it next I get an alert that say something like: "Excel has found unreadable content in this file ..." when I click out of it, it then proceeds to delete all of the shapes on one of the sheets. This is a huge problem because most of the shapes are buttons with macros that are crucial to working with the report.
Does anyone know what is causing this and how do I fix it?