Thanks very much Bernard. It did the trick on both. I can't thank you enough.
--
mc


"Bernard Liengme" wrote:

For the second problem look at Tools | Options; open Calculation tab; is
calculation set to Manual? Change it to Automatic

Not able to copy? Tell us what happens.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mc" <april67 wrote in message
...
Hello,
All of a sudden, I am not longer able to copy a formula from one cell to
another.

Worse, if I change a cell in the formula (from 2+2 =4 to 2+3), the SUM
still
reads 4.

Any help would be greatly appreciated.

--
mc