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!