Formula correct, answer wrong
 

I have a spreadsheet that when I copy the formula, it copies correctly
(changes the cells it should subtract), however, the result stays the same.
It matches the formula I copied it from, even though the cells to calculate
are now different. I even did a paste special and said only formula, but
still, same result. If I actually type in the formula, it works fine, but I
have a lot I need to copy and paste. Is there a way I can fix this?

Thanks,

Formula correct, answer wrong
 

Perhaps you have calculations set to Manual.

Press F9 to confirm. Calculations should now work.


To set to automatic calcs:

Go to Tools|Options and in the Calculation Tab, set Calculation to
Automatic.

Click Ok.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497619

Formula correct, answer wrong
 

It sounds as though you have manual calculation set.

Go to ToolsOptionsCalculation, and click the Automatic button.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TJAC" wrote in message
...
I have a spreadsheet that when I copy the formula, it copies correctly
(changes the cells it should subtract), however, the result stays the
same.
It matches the formula I copied it from, even though the cells to
calculate
are now different. I even did a paste special and said only formula, but
still, same result. If I actually type in the formula, it works fine, but
I
have a lot I need to copy and paste. Is there a way I can fix this?

Thanks,