Copy of formulas error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 :-)
------------------------------­------------------------------­----------------
 
That was it!
Thanks a lot!!!

Ken Wright said:
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 :-)
------------------------------­------------------------------­----------------
Click to expand...
 
Back
Top