When the Excel Options screen is displayed, choose the Save option from the side panel on the left. Open an Excel file, go to the File menu in the upper-left corner of your Excel file.Ĭhoose the Options entry at the bottom of the screen.

In short, Compatibility Mode is designed to keep documents viewable by everyone. Hit the drop-down menu next to it and select.Find the Save files in this format option heading.Select the Save option from the side panel.Still, if you would like to disable the feature, here’s what you need to do. For example, if you’ve upgraded to a new version of Microsoft Excel, and fear that you won’t be able to share workbooks with people who haven’t upgraded yet, the Compatibility mode will resolve those issues before you start sharing files. How to Turn off Compatibility Mode in ExcelĬompatibility mode ensures that older versions of Excel remain compatible with the modern versions. For example, if you open the Excel file created on older versions in newer versions, you will see the Compatibility Mode on the ribbon. The Compatibility Mode is the viewing mode in Microsoft Office applications, like Word, Excel, etc., that allows users open or view the documents created on other versions of Office applications. The Compatibility Mode allows users to open Excel files created on other versions of Excel. That’s why Microsoft introduced the Compatibility Mode for Microsoft Excel and other applications. Excel files created in older versions may not be compatible with newer versions and vice versa. Hence, there are different versions of Microsoft Excel. Microsoft has released different versions of Office till now. You should know that without Compatibility Mode, some documents may display incorrectly or not open at all. It’s often mistaken as a warning message but in reality, Compatibility Mode is a check done to ensure things do not go awry. While attempting to open some Excel files on your computer, you must have seen the Compatibility Mode message being displayed in the title bar of the file.

Disable links in excel 2003 spreadsheet