copy formula

J

Jo

I just upgraded to office 2003. When I get a lower
version file from someone, and I do a copy and paste, it
copies the exact same formula with the $ sign which I
cannot see where to get rid of.

The calculation box is set to automatic, not manual. How
do I resolve this? I didn't have that problem before.

Thanks.
 
F

Frank Kabel

Hi
this has nothing to do with the Excel version. In this
case the formulas was entered with absolute references
(the $ signs). If you want the references to change you
have to delete these $ signs. Either manually or clicking
on the reference and hitting F4 to toggle between the
reference styles
 
J

JO

Even though I take out the $ sign, it doesn't work. This
below is how it shows when all I want is for it to say
G12-F12. Besides manually writing the G12-F12, I don't
know why it's saying that. Again, I just upgraded to
version 2003 and never had that problem before.

GETPIVOTDATA("Total Costs",$A$10,"Class 1000","1000")-
GETPIVOTDATA("Total Costs",$A$10,"Period","JUNE","Class
1000","1000")
 
Top