Excel not copying
 

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.

Excel not copying
 

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.

Excel not copying
 

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.
....