Hi Guys!
I have a user who has the following problem:
He has created a pivot table and from outside the pt area he has created a formula. When I go into the cell it references on the formula bar =H5/$H$22
Now when he tries to do the same thing in the cell below he gets this information in the formula bar :
=I4=GETPIVOTDATA("Vehicle No",$A$3,"Model Desc","COMBO 1700 1.3CDTi 16v 5SPD")/GETPIVOTDATA("Vehicle No",$A$3) instead of the expected =H6/$H$22
Does anyone know why??? I've looked in Tools\Options - the format of the cells etc but I just can't seem to get it to just revert to basic cell references??
Thanks for your help!
Bookmarks