View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.