Issue: Cannot Convert PivotTable cells to worksheet formulas

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.