Wednesday, February 7, 2018

Issue: Cannot Convert PivotTable cells to worksheet formulas

Issue: Cannot Convert PivotTable cells to worksheet formulas

Symptoms

Microsoft Office 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.

No comments:

Post a Comment