Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulas | Excel Discussion (Misc queries) | |||
copying formulas | Excel Discussion (Misc queries) | |||
copying formulas | Excel Discussion (Misc queries) | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
Copying formulas | Excel Discussion (Misc queries) |