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Įxcel versions. To deal with the issue, Microsoft added Compatibility Mode to Excel. Your steps may differ if you use another version.
Put a check mark in the "Check Compatibility When Saving This Workbook" check box if you want Excel to check the document's compatibility in the future automatically.Ĭhecking compatibility in Excel 2013. Launch the Compatibility Checker by clicking "File," selecting "Info," and then clicking "Check for Issues." The Compatibility Checker window opens and displays compatibility issues it finds. While working with an Excel version higher than 2010, you can run the Compatibility Checker manually to create documents For example, if you’re working in Excel 2013, it converts the document into that format to give you the ability to take advantage of Excel 2013’s latest features. Exit Compatibility Mode by clicking "File," selecting "Info," and thenĬlicking "Convert." Excel converts the document into the current Excel format that matches the application version you’re using. This ensures that you do not add enhanced features to the document that people using an older Excel version cannot view. In this mode, you can’t use any newer functionality that your newer Excel version provides. Workaround, click the "Help" link next to an item.Īfter you save a workbook in an older format, Excel runs in Compatibility Mode.
To learn more about a compatibility issue or discover a possible While the Compatibility Checker window is open, click the "Find" link next to an item to jump to the location in the document that has the compatibility problem. You have two options when the Compatibility Checker discovers issues: save your document in a newer Excel format, or click "Continue" to save it in the older version and lose some functionality. For example, a list item may inform you that your document contains table references that Excel 97-2003 versions don’t support. The window also displays a list of those features for you to review. The Compatibility Checker window warns you that your document may lose some features or those features may be degraded if you save it in the older format. Find what Compatibility Mode your document is usingĮxcel's Compatibility Checker runs automatically when you attempt to save a workbook in the "Excel 97-2003 (*.xls)" format.How to save a document in Compatibility Mode.
0 kommentar(er)
