Forum Discussion

bardaguera's avatar
bardaguera
Copper Contributor
Oct 09, 2019

Unable to edit calculate values in a PivotTable

I have a pivot table, created by my colleague; it includes calculated values, and I am unable to see its formulas.

The following steps were taken:

1) select cell in the pivot table;

2) click "Fields, Items & Sets" ( "PivotTable Analysis" on the ribbon);

3) choose "Calculated Field."

Here I expect to see existing calculating fields in the "Name" drop-down list.

DD list is empty.


As a workaround, I take a look at another excel-file with those values (excel-university.com/edit-pivottable-values) but faced the same problem.

3 Replies

Resources