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.