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 |
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 |
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 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com