Forum Discussion
Excel not allowing naming of a cell in a pivot table
I am using Excel for Mac, Version 16.76. I have two tabs in my excel file and the second tab contains a pivot table. I am trying to name certain cells in that table so that I can create links on th...
As far as I can see the only cell of a Pivot Table worth referencing directly is the top-left cell that positions the PT; everything else changes each time the user sorts, filters or pivots the table.
The standard method of referencing data values from a PT is by using GETPIVOTDATA
= GETPIVOTDATA("value",
pivotRef,
"letter", selectedLetter,
"attribute", attributeValue
)