Problem in linking pivot table cell-GETPIVOTDATA appears

%3CLINGO-SUB%20id%3D%22lingo-sub-1333522%22%20slang%3D%22en-US%22%3EProblem%20in%20linking%20pivot%20table%20cell-GETPIVOTDATA%20appears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333522%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20bit%20difficulty%20in%20linking%20pivot%20table%20cell%20as%20shown%20in%20picture.%20I%20am%20trying%20to%20link%20cell%20B4%20and%20when%20I%20do%20that%2C%20the%20red%20rectangle%20marked%20area%20in%20the%20picture%20happens.%20But%20I%20need%20cell%20B4%20to%20be%20linked%20directly.%20Could%20you%20please%20help%20me%20out%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22xl%20prob.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186305i5B106222DEF580FC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22xl%20prob.jpg%22%20alt%3D%22xl%20prob.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1333522%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341574%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20in%20linking%20pivot%20table%20cell-GETPIVOTDATA%20appears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F634890%22%20target%3D%22_blank%22%3E%40Abu_Jiad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20not%20click%20on%20the%20cell%20to%20build%20the%20formula.%20When%20you%20do%2C%20the%20formula%20will%20be%20built%20using%20GETPIVOTDATA.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInstead%2C%20type%20the%20address%20of%20the%20cell%20in%20the%20PivotTable%20to%20build%20the%20formula.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?xl prob.jpg

 

1 Reply

@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.