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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.