PivotTable report compatibility issues

The Compatibility Checker found one or more compatibility issues related to PivotTable reports.

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. Issues that cause a minor loss of fidelity might or might not need 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 Excel.

Compatibility issues that cause a significant loss of functionality

Compatibility issues that cause a minor loss of fidelity

Compatibility issues that cause a significant loss of functionality

Issue

Solution

A PivotTable in this workbook exceeds former limits and will be lost if it is saved to earlier file formats. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel.

In Excel 2007, a PivotTable report supports 1,048,576 unique items per field, but in earlier versions of Excel, only 32,500 items per field are supported.

In the Compatibility Checker, click Find to locate the PivotTable report that exceeds the former limits. When you save the workbook to Excel 97-2003 format, you can then re-create this PivotTable report in Compatibility Mode.

For more information, see:

Use Office Excel 2007 with earlier versions of Excel

Working with different PivotTable formats in Office Excel

A PivotTable in this workbook contains conditional formatting rules that are applied to cells in collapsed rows or columns. To avoid losing these rules in earlier versions of Excel, expand those rows or columns.

To avoid losing conditional formatting rules that are applied to cells in collapsed rows or columns, you should expand those rows and columns before you save the workbook in an earlier Excel file format.

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.

For more information, see:

Add, change, or clear conditional formats

Top of Page

Compatibility issues that cause a minor loss of fidelity

Issue

Solution

A PivotTable style is applied to a PivotTable in this workbook. PivotTable style formatting cannot be displayed in earlier versions of Excel.

In Excel 2007, you can quickly format a PivotTable report by applying a theme-based PivotTable style. In earlier versions of Excel, you can only format a PivotTable report manually.

In the Compatibility Checker, click Find to locate the PivotTable report that has a PivotTable style applied, and then remove that PivotTable style.

For more information, see:

Working with different PivotTable formats in Office Excel

A PivotTable in this workbook is built in the current file format and will not work in earlier versions of Excel. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel.

A PivotTable report that was created in the Excel 2007 file format cannot be refreshed in earlier versions of Excel. To avoid this issue, you may want to work in Compatibility Mode. When you create a PivotTable report in Compatibility Mode, you can open it in earlier versions of Excel without loss of functionality.

In the Compatibility Checker, click Find to locate the PivotTable report that is created in the current file format. When you save the workbook to Excel 97-2003 format, you can then re-create this PivotTable report in Compatibility Mode.

For more information, see:

Use Office Excel 2007 with earlier versions of Excel

Working with different PivotTable formats in Office Excel

A PivotTable in this workbook has fields in compact form. In earlier versions of Excel, this layout will be changed to tabular form.

In Excel 2007, you can use compact form (alone or in combination with tabular and outline form) to keep related data from spreading horizontally off of the screen and to help minimize scrolling — fields are contained in one column and are indented to show the nested column relationship. In earlier versions of Excel, only outline form and tabular form are supported.

In the Compatibility Checker, click Find to locate the PivotTable report that has fields in a compact form, and then change that format to tabular form as needed.

For more information, see:

Working with different PivotTable formats in Office Excel

Design the layout and format of a PivotTable report

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×