|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2009, 04:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula down - cell references change - result is same for al
Hello,
I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace 
|
|
#2
November 13th, 2009, 04:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same foral
ace wrote:
Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! Check that calculation is set to automatic.
|
|
#3
November 13th, 2009, 04:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Make sure calculation is set to automatic.
Excel 2007: Formulas tabCalculationCalculation OptionsAutomatic All other versions of Excel: ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "ace" wrote in message ... Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace
|
|
#4
November 13th, 2009, 04:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Hi,
My guess is that calculation has been turned to manual. Do the formula update if you tap F9? If so E2003 Tools|Options - Calculation tab and select automatic E2007 Office button - Excel options - Formulas and select automatic Mike "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace
|
|
#5
November 13th, 2009, 05:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Do you have auto or manual calculate on the spreadsheet? Go to tools,
options, calculation and see what your settings are. You may need to change it to Automatic Calculation. "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace
|
|
#6
November 13th, 2009, 09:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same fo
Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how did it get set to Manual? :-) -- ace "Mike H" wrote: Hi, My guess is that calculation has been turned to manual. Do the formula update if you tap F9? If so E2003 Tools|Options - Calculation tab and select automatic E2007 Office button - Excel options - Formulas and select automatic Mike "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace
|
|
#7
November 13th, 2009, 09:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same fo
ace wrote:
Thanks to all of you smart people who knew the answer to my problem. It was in fact the manual setting in the formula options. My next question is, how did it get set to Manual? :-) Excel uses the calculation setting from the first workbook that is opened.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
