Data in cells outside of this column and row limit is lost in Excel 97-2003. What it means Beginning with Excel 2007, the worksheet size is 1,048,576 rows tall by16,384 columns wide, but Excel 97-2003 is only 65,536 rows tall by 256 columns wide. Formula references to data in this region will return a #REF! error. Data beyond 65,536 rows tall by 256 (IV) columns wide will not be saved. This workbook contains data in cells outside of the row and column limit of the selected file format. xlsx files to be able to open the workbook, consider opening the workbook in Excel for the web and sending the file URL to them at an email address that is registered as a Microsoft Account. What to do To preserve the labels, avoid saving the workbook in. xlsx format the labels will be preserved, but won’t display in Excel 2016 or earlier versions. xls format, the labels will be permanently lost. What it means If you save this workbook in. This workbook has label information that will be lost or not visible if the file is saved as an earlier Excel format. Unsupported worksheet features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity.
When run automatically, the Compatibility Checker also specifies the version of Excel in which a potential compatibility issue occurs. You can then locate all occurrences of the issue, and get information about ways to resolve the issue. The Compatibility Checker lists the compatibility issues it finds, and provides a Find and Help button for many issues.
#HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2011 HOW TO#
For information about how to run the Compatibility Checker, see Check an Excel workbook for compatibility with earlier versions of Excel. You can then specify that the Compatibility Checker runs automatically every time that you save that workbook. However, to verify that a workbook is compatible with your current version of Excel, you must run the Compatibility Checker manually the first time you save the workbook. When you save a workbook to an Excel 97-2003 file format, the Compatibility Checker runs automatically. To avoid the loss of data or functionality in an earlier version of Excel, you can then make the necessary changes to your current workbook. When you work in Compatibility Mode or want to save aworkbook to the Excel 97-2003 (.xls) file format, the Compatibility Checker can help you identify issues that may cause a significant loss of functionality or a minor loss of fidelity in the earlier version of Excel. Not all new features are supported in earlier versions of Excel. New features that are not supported in earlier versions of Excel For information, see Convert a workbook to a new file format. If you no longer want to work in Compatibility Mode, you can convert the workbook to the current file format.
Unlike other Office programs, such as Word, you cannot manually turn on Compatibility Mode in Excel, and you do not have the option to include any new features when you work in a workbook in Compatibility Mode. xltm), the workbook is saved in Excel 97-2003 file format (.xls), a file format that can be opened by earlier versions of Excel. Also, instead of using a current file format (.xlsx. In Compatibility Mode, any new or enhanced Excel features are not available, which prevents loss of data and fidelity when the workbook is opened in an earlier version of Excel. In Excel 2010 and later, when you open a workbook that was created in Excel 97-2003, it is automatically opened in Compatibility Mode, and you see Compatibility Mode in square brackets next to the file name in the Excel title bar. You can then make the necessary changes to avoid the loss of data or fidelity that might occur when that workbook is opened in an earlier version of Excel. Compatibility mode is not available for Excel 2007 workbooks.Ĭheck a workbook for compatibility If you want to work in the current file format but have to share a workbook with people who use earlier versions of Excel, you can check that the data is compatible with earlier versions of Excel. Work in Compatibility Mode You can open a workbook that was created in an earlier version of Excel and work in Compatibility Mode so that the workbook remains in a file format that can easily be opened again in the earlier version. LessĪfter you have installed a new version of Excel, you may want to know how you can continue to work with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who do not have the current version of Excel installed, and how the differences between the versions affect the way that you work.įor backward compatibility with earlier versions of Excel, such as Excel 97-2003, you can use one of two ways to exchange workbooks between the different versions.
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More.
0 kommentar(er)
