copy-paste started misbehaving (cell reference wrong)

E

efffemm

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?
 
P

Peo Sjoblom

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

--


Regards,

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skip Reference Sequences during copy 3
Copy unformatted value of cell via macro 0
how to copy paste the figures in adjoining cells? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Altered pasting functionality 3
Copying cell formulas 1
Absolute and Relative Cell References 1
change change cell reference to Absolute reference 5

Top