copy & paste in excel
 

When I copy & paste a formula in excel the formula copies but does not work.
eg.
=SUM(F16:F18) is copied from =SUM(E16:E18) but the total is the same as the
original E16:18. This is happening regardless of whether I copy within a
worksheet of from one worksheet to another. If I double click to edit the new
formula it works. What is happening?? I don't want to have to edit alll cells
I copy and paste.

Trish

copy & paste in excel
 

Tools/ Options/ Calculation
Set to Automatic, not Manual.
--
David Biddulph

"Trish" wrote in message
...
When I copy & paste a formula in excel the formula copies but does not
work.
eg.
=SUM(F16:F18) is copied from =SUM(E16:E18) but the total is the same as
the
original E16:18. This is happening regardless of whether I copy within a
worksheet of from one worksheet to another. If I double click to edit the
new
formula it works. What is happening?? I don't want to have to edit alll
cells
I copy and paste.

Trish