PivotTable styles in earlier versions of Excel

Cause: The workbook contains PivotTables that have style formatting that cannot be displayed in earlier versions of Excel.

Solution:    Remove PivotTable styles.

  1. To remove the formatting, on the Compatibility Report, in the Results box, click the Workbook contains PivotTable styles that are not available in earlier versions of Excel error message. This selects the PivotTable.

    If there are multiple PivotTables, the Results box shows an error for each PivotTable.

  2. On the PivotTable tab, under PivotTable Styles, rest your pointer on a style, and then click More Down Arrow .

    PivotTable tab, PivotTable Styles group

  3. Click Clear PivotTable Style.

    To verify that the formatting is removed, on the Compatibility Report, click Check Document or Recheck Document. The related error message disappears.

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!