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

Hi Ed

It sounds as through you have inadvertently pressed the option for Paste
SpecialValues.
At the side of the Paste clipboard icon, there is dropdown arrow which
allows you to copy Formulas, Values, etc.
Just clicking the icon itself, the default behaviour would be to copy
everything about a cell's properties, including the formula contained
within it.

--
Regards

Roger Govier


"Ed" wrote in message
...
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