Issue: Cannot Convert PivotTable cells to worksheet formulas


Excel cannot convert the PivotTable to formulas.


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.


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 the Answers community.

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.