I am trying to find a way on the newer version of Excel where I can create a formula that links into a pivot table by clicking with the mouse on the particular cells I want to use in the formula without it producing the huge reference text string that you cannot copy down.
Currently my only work around is to manually type in cell addresses such as "a2+b2" etc instead of when I click on cells I get
"=GETPIVOTDATA("4",$A$3,"1",4)+GETPIVOTDATA(
"4",$A$3,"1",4)"
but I was hoping someone knew of a setting that would disable this and simply give the cell reference when clicked on.
Any ideas would be greatly appreciated