Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert a static formula to dynamic formula ?
I'm using relative referencing, but what exactly happening is when I copy the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is =A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is the value not changing ? I'm aware of absolute referencing and i've checked for the $ sign in the formula and there aren't any. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert a static formula to dynamic formula ?
Check that you don't have manual calculation set, ToolsOptionsCalculation,
there are option buttons for Automatic and Manual. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pisistratus" wrote in message ... I'm using relative referencing, but what exactly happening is when I copy the formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is =A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is the value not changing ? I'm aware of absolute referencing and i've checked for the $ sign in the formula and there aren't any. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert a static formula to dynamic formula ?
probably it is not the referencing but that you need to go to
toolsoptionscalculations and select automatic. "Pisistratus" wrote: I'm using relative referencing, but what exactly happening is when I copy the formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is =A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is the value not changing ? I'm aware of absolute referencing and i've checked for the $ sign in the formula and there aren't any. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert a static formula to dynamic formula ?
You probably have the sheet set to manual calculation - press F9 to
force a re-calculation. Go to Tools | Options | Calculation tab and check Automatic and OK. Hope this helps. Pete On Jul 5, 1:42 pm, Pisistratus wrote: I'm using relative referencing, but what exactly happening is when I copy the formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is =A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is the value not changing ? I'm aware of absolute referencing and i've checked for the $ sign in the formula and there aren't any. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trick a Dynamic Name to be Static when SOLVER is ON... | Excel Worksheet Functions | |||
Dynamic data, static range, not updating. | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
static time in formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |