Unable to edit calculate values in a PivotTable

[bardaguera]

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.

[#2]

Maybe Power Pivot was used to create the file? Probably best to ask your colleague

[#3]

@PascalKTeam 

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

[#4]

@bardaguera 

is it possible that you post the file so we can take a look?