Why does a copied formula display the original answer?

[Martha Rade 1956]

Using Excel 2000 SP3. Sometimes, I'll set up a formula in a cell, using
other columns' values. Even a simple copy of another column's cell. Then,
when I copy the formula and paste it to the rest of the cells in my new
column, I get all the new formulas but the value of each formula displayed is
the value of the original cell. What gives? I've tried everything, even
copying the source column onto Notepad and back onto a new, fresh, Excel
template. Still get the same results. Restarting Excel doesn't help; nor
does rebooting the computer. Running Windows 2000. Thanks for any advice.
This has happened three times so far this year.

 

[Ken Wright]

Tools / Options / Calculation Tab / Tick 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
------------------------------­------------------------------­----------------

 

[Ray S]

If the automatic switch isn't the issue for calculation mode, check to see if
the formulas are absolute (has a "$" in front of the cell reference). If
there absolute references they'll carry the exact same formula as the source
cells.