For backward compatibilty, I have been building and releasing all of the Excel files in 2003 format, which end with .XLS. If you open one of these files in Excel 2007 or later, then try to save it, it's going to try to save it in Excel 2003 format. When it does so, it runs this Compatibility Checker, which claims that there are problems saving to the "old" format, but in reality, there are no problems.
I've been searching the web and I've seen a couple of comments about how nice it is to warn us about possible problems, but how rude it is to not provide a tool that would alow us to track down the source of the problem to fix it. A classic Microsoft-ism.
Based on everything I see, the problems that the Compatibility Checker warns us about have no effect on what we are doing.
The Compatibility Checker can be "silenced" in a couple of different ways.
- When the Save As... window appears, select Excel Macro-Enabled Workbook (*.xlsm). This will also stop the Checker from appearing, but for only this file.
- When the Compatibility Checker appears, uncheck the box that says Check compatibility when saving this workbook. This will stop the Checker from appearing, but again, only for this file.