Excel not allowing naming of a cell in a pivot table

Question

I am using Excel for Mac, Version 16.76.&nbsp; I have two tabs in my excel file and the second tab contains a pivot table.&nbsp; I am trying to name certain cells in that table so that I can create links on the first tab in order to take you directly to that spot on the pivot table.&nbsp; I've tried to right click the cell I want to name and use alternative text.&nbsp; It lets me enter the name I want, but when I hit "enter" the name does not change.&nbsp; Also tried changing directly by highlighting the cell number up in the top left coprner below the menu and it will not accept either.&nbsp; Appreciate any thoughts.

jkpieterse · Answer

I assume you are aware of the fact that refreshing the pivot table may cause the cell you linked to to contain a value "belonging" to an entirely different set of categories?

peterbartholomew1 · Answer

Chuck0725&nbsp;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
  )&nbsp;

Forum Discussion

Excel not allowing naming of a cell in a pivot table

Share

Resources