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