Copy of formulas error

[bigdaddy037]

I have seen this problem on two different worksheet on two different
computers now ...

When copy and pasting a formula for a row:
- The formula copies and shows correctly when you look at the formula in the
cells
- but, the value that shows in the cell is the same value from the original
(copied) cell, even though the formula should output a different value.

This is very wierd, one is happening on a worksheet that has been working
correctly for over 6 months and this has just started happening, the other on
someone elses computer using a different worksheet/file altogether.

Thanks in advance for your help

 

[Ken Wright]

If hitting F9 fixes it, then try tools / options / calculation - set to
automatic.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[bigdaddy037]

That was it!
Thanks a lot!!!

If hitting F9 fixes it, then try tools / options / calculation - set to
automatic.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Ken Wright]

You're welcome

Regards
Ken................

That was it!
Thanks a lot!!!