Apr 23 2020 01:26 PM
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?
Apr 27 2020 01:14 PM
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.