Related Content: How to Remove Error in Excel (8 Methods) And you can apply all the features available in your Excel version to the workbook. You also see the Accessibility status as Good to go since the file is in the new format (i.e., xlsx Excel format). You see no Compatibility Mode written in the file name similar to the image below. Step 4: Open the duplicate newer Excel file you just saved in Step 3. You can see the previous version of the file is in the Excel older version (i.e., Excel 97-2003 Workbook (*.xlsx)).Įxcel saves a duplicate of the file in the new format (i.e., Excel Workbook(*.xlsx)) and you can find the duplicate in the stored folder. Step 2: Afterward Select Save As option > Select a Location (i.e., This Computer) (where you want to store the file) > Select Excel Workbook (*.xlsx) as the saving format. Step 1: Hover to the File ribbon as depicted in the screenshot. As a result, we have to move from Compatibility Mode to Normal Mode by saving the Excel file in newer file formats like.
Because we won’t be able to use all the new features that are available in the current versions of Excel. It’s quite risky to work with the dataset as it is in the Compatible Mode. Therefore, it’s obvious that the file is saved in a different version of Excel than ours. Let’s say after opening a dataset, we encounter Compatibility Mode appearing in the tail of the file name. xls extension gets opened in Excel newer versions, Excel shows Compatibility Mode note after the file’s name at the top of any workbooks.Ģ Easy Ways to Remove Compatibility Mode in Excel Method 1: Using Save As Option to Remove Compatibility Mode in Excel In the window, you see the saved file version in Excel as shown in the below image.Įxcel Common File Types Regarding Excel VersionsĮxcel Macro-Enabled Workbook (newer version) ➤ The Compatibility Checker window opens. ➤ Select the Info option (on the left side of the window) > Choose the Check for Issues option (on the right side of the window) > Select Check Compatibility (from the options). ➤ Go to the File ribbon as depicted in the following screenshot. To find the Compatible Mode type or Excel version of the file follow the below sequence, However, it doesn’t indicate which Compatible Mode is the Workbook or Excel file in. We know just by looking at the Worksheet that any file is in Compatible Mode. You can also see the Accessibility customize bar status option indicating Unavailable as the dataset is in Compatibility Mode.įinding Compatible Mode Type or Excel Version of a File See the following screenshot to clarify the instance. After opening the workbook, you see the workbook name at the top of the workbook in filename-Compatibility Mode format. In a scenario, you get an Excel file saved in older versions of Excel (i.e., Excel 1997 to 2003) from external sources other than what you are using.