how to convert an excel file from compatibility mode?
Excel Compatibility Mode Exit Compatibility Mode by clicking "File," selecting "Info," and then clicking "Convert." Excel converts the document into the current Excel format that matches the application version you're using.