copy-paste started misbehaving (cell reference wrong)
 

I have Excel 2003 SP2
Usually if enter a formula like =B3-B2 into a cell, and copy and paste
it,
I got relative reference in the destination, e.g. cell below would
become
B4-B3
Now when I paste, every cell gets =B3-B2, therefore the same value.
I tried selecting the source cell and pressing F4 key to cycle through
absolute and relative reference - that didn't help.
I am using control-c control-v not paste special.
Fortunately I have Open Office as well to get me out of a pickle,
but I wish to know:
What has happened to Excel?

copy-paste started misbehaving (cell reference wrong)
 

Most likely you have the calculations set to manual, what happens if you
press F9?
Toolsoptionscalculation, change to automatic is where to change it

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

wrote in message
ups.com...
I have Excel 2003 SP2
Usually if enter a formula like =B3-B2 into a cell, and copy and paste
it,
I got relative reference in the destination, e.g. cell below would
become
B4-B3
Now when I paste, every cell gets =B3-B2, therefore the same value.
I tried selecting the source cell and pressing F4 key to cycle through
absolute and relative reference - that didn't help.
I am using control-c control-v not paste special.
Fortunately I have Open Office as well to get me out of a pickle,
but I wish to know:
What has happened to Excel?