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. It’s often mistaken as a warning message but in reality, Compatibility Mode is a check done to ensure things do not go awry. You should know that without Compatibility Mode, some documents may display incorrectly or not open at all.
What is Compatibility Mode in Excel?
Microsoft has released different versions of Office till now. Hence, there are different versions of Microsoft Excel. Excel files created in older versions may not be compatible with newer versions and vice versa. That’s why Microsoft introduced the Compatibility Mode for Microsoft Excel and other applications. The Compatibility Mode allows users to open Excel files created on other versions of Excel.
Why is my file in Compatibility Mode?
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. For example, if you open the Excel file created on older versions in newer versions, you will see the Compatibility Mode on the ribbon.
How to Turn off Compatibility Mode in Excel
Compatibility mode ensures that older versions of Excel remain compatible with the modern versions. 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. Still, if you would like to disable the feature, here’s what you need to do.
- Open an Excel file.
- Click File.
- Choose Options.
- Select the Save option from the side panel.
- Find the Save files in this format option heading.
- Hit the drop-down menu next to it and select .xlsx Excel workbook.
- Click OK.
In short, Compatibility Mode is designed to keep documents viewable by everyone.
Open an Excel file, go to the File menu in the upper-left corner of your Excel file.
Choose the Options entry at the bottom of the screen.
When the Excel Options screen is displayed, choose the Save option from the side panel on the left.
Under the Save Workbooks section on the right, look for the Save files in this format heading. Hit the drop-down button next to it and from the list of options displayed select .xlsx option.
Hit the Ok button at the bottom of the window to save all your Excel files in .xlsx file format by default. This will also turn off the Compatibility Mode in Excel.
How to turn off Excel Compatibility Mode in Office 365?
There’s also an alternative way to disable the Compatibility mode in Excel. Here’s how!
Go to File Menu > Info. Then, hit the Check for issues drop-down button under Inspect Workbook heading.
Select the Check compatibility option from the list.
When the Compatibility Checker window opens, uncheck the box next to check compatibility when saving this workbook heading as shown in the image above.
Hope it helps!
Read: Free Office Viewers from Microsoft to view Word, Excel, PowerPoint, Visio files.