Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

Symptoms

Excel cannot convert the PivotTable to formulas.

Cause

One or more filtered fields are not completely visible. To convert a cell to a formula, all items that are used in the formula must be visible.

Resolution

To make the filtered fields completely visible, do one or more of the following:

  • Expand the entire field for all fields in levels above the filtered fields.

  • If grand totals are displayed, display the subtotals as well.

Then, try to convert the PivotTable cells to worksheet formulas again.

For more information, see Expand or collapse details in a PivotTable report or PivotChart report and Subtotal and total row and column labels in a PivotTable report.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.