Until this morning I could copy cells with a formula containing a cell
reference and the cell reference would automatically be updated. Now, the
data and not the formula is copied and appears in the formula window.. For
Example,

A2 = C3 *1 A3 = C4 *2 C3 C4
10 50 10 25

If I copy select and copy cells A2:A3 to B2:B3 and paste from the clipboard
to cells B2:B3.

B2 B2 D3
D4
10 50 17 501

Fomerly, B2 = D3 * 1 and B3 = D4 * 4 would appear in the formula bar and
the data displayed in the cells would be B2= 17 AND B3 = 1002.
Where and what is the setting to return to the previous behavior?

Thanks

--
Ed