However, don't convert a document if you or someone else needs to work with it using an older version of Excel. You can easily leave the Compatibility Mode view when you're done working with a document. This is the Compatibility Mode the document is currently using. Click on the Select Version to Show box and look for a checkmark. You should be returned to your document with a new window open.A drop-down menu should appear where you can select Check Compatibility. Go to the Info tab and click on the Check for Issues button.You can tell this by looking at the document name, which should display like this: Workbook.xls - Excel Open the document that’s already in Compatibility Mode.This is useful when you’re viewing a document you received from someone. Run Excel's compatibility checker to see what mode is being used to view the document you have open. Here, simply choose an older version of Excel you wish to convert to.įind what Compatibility Mode your document is using Click on the drop-down menu that displays Excel Workbook (*.xlsx) by default.Open the document you want to save in Compatibility Mode.On the other hand, those who work with recent releases have to prep their documents to ensure others can open it properly. 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. This means that you can only enter this viewing mode if you’re working with a file specifically created for this mode. How to save a document in Compatibility ModeĬompatibility Mode applies to documents saved in or saved for older versions of Excel. Since Excel has been around for so long, a lot has changed in its fundamentals which are addressed by Compatibility Mode.
MAC EXCEL 2013 SOME FILE SLOW TO OPEN SOFTWARE
This is common when software updates change the core of an application over time. Without Compatibility Mode, some documents may display incorrectly or not open at all. If you're using an older version, Compatibility Mode ensures that you can view workbooks made in newer releases as well. When creating a workbook in Compatibility Mode, it's going to be viewable in old Excel versions. To deal with the issue, Microsoft added Compatibility Mode to Excel. However, most users aren’t aware of this. It depends on the contents of a document, which is a tricky thing to take into consideration.įor example, a feature implemented in Excel 2019 most likely won't display properly in Excel 2013. This inevitably means that documents made in newer versions may not be compatible with old releases. What is Excel’s Compatibility Mode?Ĭompatibility Mode is a viewing mode in Excel that helps you create documents viewable by everyone.Įxcel is available in many versions since it has been around for over a decade. This article goes in-depth about everything you need to know related to the Compatibility Mode view. It can save you a lot of time and effort, especially if you work with people that use different versions of Excel.
MAC EXCEL 2013 SOME FILE SLOW TO OPEN HOW TO
Many Excel users aren’t aware of the existence of Compatibility Mode and how to use it properly.