EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Formula and Functions Compatibility Mode in Excel

Compatibility Mode in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated July 4, 2023

What is the Compatibility Mode in Excel?

The Compatibility mode in Excel helps find compatibility issues in Excel workbooks and alerts the user if any errors occur. It ensures that users of older Excel versions can also view the file in the new version.

For example, Microsoft recently added 6 new features to Excel 2019- CONCAT, MAXIFS, MINIFS, TEXTJOIN, IFS, and SWITCH. Now, if users with older versions of Excel, such as 2016 or 2013, try to open Excel 2019, they will get compatibility errors. Here the feature of ‘Compatibility Mode’ comes to the rescue.

If a user converts the Excel 2019 file into compatibility mode and shares it with his friend with Excel 2016, his friend can view the file.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Key Highlights

  • The compatibility mode is the feature that warns the user of any compatibility issues found in the workbook.
  • We can view the compatibility mode when we save the Excel file in the older format (.xls).
  • When you open an Excel file, the document name in the title bar will look like this: xls [Compatibility Mode].
  • Once you disable the compatibility mode, it enables the additional features from your file’s current (new) version.

How to do Excel Compatibility Mode Features Work?

You must create a new document to understand how compatibility features work in Excel. It will help you understand the practicality of the element.

Let’s understand it through the steps:

Step1: Click on the File tab, and click on the Save As

Compatibility Mode in Excel-Step 1

Step 2: To save the file in Excel, use the .xlsx extension

Step 3: Select where you want to save the file. The folder on your desktop to save the file

Compatibility Mode in Excel-Step 3

Step 4: To save the file in the compatibility mode, select the .xls (older format)

Step 5: Select Excel 97-2003 Workbook from the drop-down list in the Save as type textbox.

Compatibility Mode in Excel-Step 5

Step 6: Mention the file name and click on Save

Compatibility Mode in Excel-Step 6

How to Remove Compatibility Mode in Excel

We cannot use most features when we open an Excel workbook in compatibility mode. Thus, we can revert to the normal mode (exit compatibility mode) to access all the Excel functions.

Let’s understand the process of removing compatibility mode in Excel:

Step 1: Open a pre-existing document

Step 2: Click the File menu and locate Options in the More section.

Compatibility Mode in Excel-Step 2

Step 4: Select the Options icon to open the Excel Options window, as shown below. Then, go to the Save tab on the left side panel.

Step 4

Step 6: Click the drop-down button next to the Save files in this format and choose the Excel workbook (.xlsx) format from the list.

Step 6.2

Step 7: Click on OK to save it.

Also, it is essential to note that the original Excel workbook gets deleted after conversion, and you cannot restore it.

How to Change Compatibility Mode in Excel

We cannot use the majority of the Excel features when we open an Excel workbook in compatibility mode. Thus, to access all the functions, we can revert back to the normal mode (exit compatibility mode).

To leave compatibility mode in Excel, follow the below-given steps:

Step 1: Open the desired Excel file that is in compatibility mode.

step 1.1

Step 2: Click on File and then click on Info

Step 2.2

Step 3: Choose the Convert option to bring the file temporarily back to normal mode.

Step 3.1

Step 4: Select OK, and your worksheet will leave compatibility mode

Step 4.1

The above popup message will indicate that you now have a successfully converted Excel file format.

Now, Excel will again display a message asking if you want to use the new and enhanced features of the current Excel file format, as shown below,

Step 4.2

  1. Click Yes if you want to use the enhanced features.
  2. You can now see no Compatibility Mode in the file name. The file will now work in newer Excel versions having all the functionalities.

Example

Compatibility checking in the Excel 2013 version

When the Compatibility Checker is enabled in the 2013 Excel version, it shows the below warning:

Example

Things to Remember

 

  • Users can leave compatibility mode or convert the file to normal mode.
  • After conversion, Excel will delete the original workbook, which you cannot restore. You should be aware of the following points before leaving the Excel compatibility mode:

Frequently Asked Questions(FAQs)

Q1. What is the compatibility mode in Excel?

Answer: Excel compatibility mode is a viewing mode that enables users to create documents that can be viewed by everyone using any version. Excel displays [Compatibility Mode] in the title bar, which indicates that you have opened an old XLS file, usually created by 1997 through 2003 versions of Excel.

The later versions use XLSX files, which never run in compatibility mode. In compatibility mode, you can change to an old file and resave it without worrying about breaking compatibility with older versions.

Q2. What is the work of a compatibility checker?

Answer: The Compatibility Checker scans your Excel workbook for any Compatibility issues and displays warnings if they exist. For example, a workbook will have more than one chart unavailable in earlier Excel versions, like treemaps. The compatibility checker will remove them.

Q3. What are the issues with not leaving compatibility mode?

Answer: When a document is in compatibility mode, you might be unable to access all the features and functionalities of your current version in that workbook. You can change the compatibility mode to normal to make the workbook fully functional.

Recommended Articles

We hope this EDUCBA article was helpful to you. For more Excel-related information, EDUCBA would recommend the below articles.

  1. Date Ranges in Excel
  2. Simple Formula in Excel
  3. Calculations in Excel
  4. Logical Functions in Excel
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW