Home

Unable to edit calculate values in a PivotTable

%3CLINGO-SUB%20id%3D%22lingo-sub-901964%22%20slang%3D%22en-US%22%3EUnable%20to%20edit%20calculate%20values%20in%20a%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901964%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%2C%20created%20by%20my%20colleague%3B%20it%20includes%20calculated%20values%2C%20and%20I%20am%20unable%20to%20see%20its%20formulas.%3C%2FP%3E%3CP%3EThe%20following%20steps%20were%20taken%3A%3C%2FP%3E%3CP%3E1)%20select%20cell%20in%20the%20pivot%20table%3B%3C%2FP%3E%3CP%3E2)%20click%20%22Fields%2C%20Items%20%26amp%3B%20Sets%22%20(%20%22PivotTable%20Analysis%22%20on%20the%20ribbon)%3B%3C%2FP%3E%3CP%3E3)%20choose%20%22Calculated%20Field.%22%3C%2FP%3E%3CP%3EHere%20I%20expect%20to%20see%20existing%20calculating%20fields%20in%20the%20%22Name%22%20drop-down%20list.%3C%2FP%3E%3CP%3EDD%20list%20is%20empty.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAs%20a%20workaround%2C%20I%20take%20a%20look%20at%20another%20excel-file%20with%20those%20values%20(excel-university.com%2Fedit-pivottable-values)%20but%20faced%20the%20same%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivotTable%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905816%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20calculate%20values%20in%20a%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905816%22%20slang%3D%22en-US%22%3EMaybe%20Power%20Pivot%20was%20used%20to%20create%20the%20file%3F%20Probably%20best%20to%20ask%20your%20colleague%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908572%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20calculate%20values%20in%20a%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908572%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20to%20build%20PivotTable%20from%20data%20model%20the%20%22Calculated%20Field%22%20shall%20be%20greyed%20out.%20Have%20no%20idea%20what%20it%20could%20be.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908615%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20calculate%20values%20in%20a%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422790%22%20target%3D%22_blank%22%3E%40bardaguera%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%20that%20you%20post%20the%20file%20so%20we%20can%20take%20a%20look%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
bardaguera
Occasional Visitor

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
Maybe Power Pivot was used to create the file? Probably best to ask your colleague

@PascalKTeam 

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

@bardaguera 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies