My Excel is not copying properly. When I copy paste 1A +1B, to the next line
It's still giving me 1A + 1B rather than 2A + 2B.

Also, it is suddenly not recalculating values. So when I put in a new value
in a cell the total is not changin.

If you enter a formula such as =A1 + B1 then copy/paste to another cell and it
does not change, I would suggest your ToolsOptionsCalculation mode is set the
"Manual".

Change it to "Automatic".


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 15:20:01 -0700, megan
wrote:

My Excel is not copying properly. When I copy paste 1A +1B, to the next line
It's still giving me 1A + 1B rather than 2A + 2B.

Also, it is suddenly not recalculating values. So when I put in a new value
in a cell the total is not changin.

1A and 1B are text, not cell references, so they won't change when you copy
them.
Cell references look like A1 and B1.
--
David Biddulph

"megan" wrote in message
...
My Excel is not copying properly. When I copy paste 1A +1B, to the next
line
It's still giving me 1A + 1B rather than 2A + 2B.
....