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,

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.

It sounds as though you have manual calculation set.

Go to Tools>Options>Calculation, and click the Automatic button.

--

HTH

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


"TJAC" <[email protected]> wrote in message
news:[email protected]...
> 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,