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?