

This workbook contains standalone PivotCharts that can be used to view data without a PivotTable in the worksheet. 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. Issues that cause a minor loss of fidelity Issues that cause a significant loss of functionality If you're not concerned about potential issues, you can turn the Compatibility Checker off.įor more information about the Compatibility Checker, see Save an Excel workbook for compatibility with earlier versions of Excel. The Compatibility Checker will automatically launch when you attempt to save a workbook in the Excel 97-2003. Issues that cause a minor loss of fidelity might or might not have to be resolved before you continue saving the workbook - data or functionality is not lost, but the workbook might not look or work exactly the same way when you open it in an earlier version of Microsoft Excel. Excel's Compatibility Checker can help you identify potential issues.

Before you save an Excel 2007 or newer version workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.
