What it means Named sets that are not associated with a PivotTable will be removed in Excel 97-2007.

This workbook contains named sets which are not associated with a PivotTable. What to do In the Compatibility Checker, click Find to locate the collapsed rows or columns that contain conditional formatting rules, and then expand those rows or columns before you save the workbook in an earlier Excel file format. What it means Conditional formatting rules that are applied to cells in collapsed rows or columns will be lost in Excel 97-2003. To avoid losing these rules in earlier versions of Excel, expand those rows or columns. Save the workbook to Excel 97-2003 format, and then re-create this PivotTable in Compatibility Mode.Ī PivotTable in this workbook contains conditional formatting rules that are applied to cells in collapsed rows or columns. What to do In the Compatibility Checker, click Find to locate the PivotTable that exceeds the former limits. What it means In Excel 2007 and later, a PivotTable supports 1,048,576 unique items per field, but in Excel 97-2003, only 32,500 items per field are supported. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel. Issues that cause a minor loss of fidelityĪ PivotTable in this workbook exceeds former limits and will be lost if it is saved to earlier file formats. Issues that cause a significant loss of functionality 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. Important: Before you continue saving the 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.

Pivot tables in excel 2013 issues