Hoping this is posted in the correct location.
I have a macro that creates a new workbook and pastes & formats data to 5 new sheets. It has been working flawlessly for a few weeks now. (I have attached a .txt file with the VBA script for the macro that generates the file - it is too long to enter with code tags). Until this particular file that I created today. For whatever reason, I get an error that there is a problem with some content. It only does this for this particular file, no matter how many times I delete and re-generate the file. I've tested dozens of others, and it still works.
Here is a screenshot of the message that pops up when I first open the file:
After repairing, a message confirming the repair with a link to the log file opens and this is the text within the log file:
I've been searching for a while this morning trying to figure out what it's having trouble with. There is no VBA code stored in the file that is generated, and no xml objects (at least that I can find).
The excel file that I attached brings up the error when I've tested it a few times.
How do I go about finding the issue that excel is finding?