Many Excel users aren’t aware of the existence of Compatibility Mode and how to use it properly. It can save you a lot of time and effort, especially if you work with people that use different versions of Excel. Show This article goes in-depth about everything you need to know related to the Compatibility Mode view. What is Excel’s Compatibility Mode?Compatibility Mode is a viewing mode in Excel that helps you create documents viewable by everyone. Excel is available in many versions since it has been around for over a decade. This inevitably means that documents made in newer versions may not be compatible with old releases. It depends on the contents of a document, which is a tricky thing to take into consideration. For example, a feature implemented in Excel 2019 most likely won't display properly in Excel 2013. However, most users aren’t aware of this. To deal with the issue, Microsoft added Compatibility Mode to Excel. When creating a workbook in Compatibility Mode, it's going to be viewable in old Excel versions. If you're using an older version, Compatibility Mode ensures that you can view workbooks made in newer releases as well. Without Compatibility Mode, some documents may display incorrectly or not open at all. This is common when software updates change the core of an application over time. Since Excel has been around for so long, a lot has changed in its fundamentals which are addressed by Compatibility Mode. How to save a document in Compatibility ModeCompatibility Mode applies to documents saved in or saved for older versions of Excel. This means that you can only enter this viewing mode if you’re working with a file specifically created for this mode. If you’re using an older Excel version, all files you create will be opened in Compatibility Mode when someone using a newer version of Excel views your workbook. On the other hand, those who work with recent releases have to prep their documents to ensure others can open it properly.
Find what Compatibility Mode your document is usingRun Excel's compatibility checker to see what mode is being used to view the document you have open. This is useful when you’re viewing a document you received from someone.
How to leave Compatibility ModeYou can easily leave the Compatibility Mode view when you're done working with a document. However, don't convert a document if you or someone else needs to work with it using an older version of Excel. In this case, keeping the workbook in Compatibility Mode will ensure that the older format is preserved.
Excel will issue a warning that your document might appear different after the conversion. If you agree to this, the Compatibility Mode will be removed from the document and you might notice some things displaying differently than before. If needed, make edits to correct these changes. To finalize the conversion, save the document as a modern Excel document. Doing so ensures that it no longer opens in Compatibility Mode. How to turn off Compatibility ModeSome users are faced with an issue that all new documents are opening in Compatibility Mode. Don’t worry, this can be fixed with ease. It’s most likely caused by your default setting being an older version of Excel, which causes the software to only use Compatibility Mode.
Your documents should open normally now. We hope that this article was able to help you learn what the Compatibility Mode is in Excel. Feel free to return to our page any time you need further guidance regarding Microsoft’s spreadsheet app. If you’re looking to read more articles related to modern technology, consider subscribing to our newsletter. We regularly publish tutorials, news articles, and guides to help you in your day-to-day tech life.
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less
Important:
The Compatibility Checker will automatically launch when you attempt to save a workbook in the Excel 97-2003 .xls format. If you're not concerned about potential issues, you can turn the Compatibility Checker off.
For more information about the Compatibility Checker, see Save an Excel workbook for compatibility with earlier versions of Excel.
Top of Page
Top of Page You can always ask an expert in the Excel Tech Community or get support in the Answers community. Save an Excel workbook for compatibility with earlier versions of Excel Excel formatting and features that are not transferred to other file formats |