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

  • PascalKTeam's avatar
    PascalKTeam
    Iron Contributor
    Maybe Power Pivot was used to create the file? Probably best to ask your colleague
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor

      PascalKTeam 

      If to build PivotTable from data model the "Calculated Field" shall be greyed out. Have no idea what it could be.