Forum Discussion

Abu_Jiad's avatar
Abu_Jiad
Copper Contributor
Apr 23, 2020

Problem in linking pivot table cell-GETPIVOTDATA appears

Hello everyone,

 

I am having a bit difficulty in linking pivot table cell as shown in picture. I am trying to link cell B4 and when I do that, the red rectangle marked area in the picture happens. But I need cell B4 to be linked directly. Could you please help me out?

 

office 365
  • Brad Yundt's avatar
    Brad Yundt
    MVP
    Apr 27, 2020

    Abu_Jiad 

    Do not click on the cell to build the formula. When you do, the formula will be built using GETPIVOTDATA. 

     

    Instead, type the address of the cell in the PivotTable to build the formula. 

Resources