Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referenced cell does not automatically update
In my copy of excel 2003 when i copy a formula like =A2*3 one cell below, it
changes to =A3*3 This is what is supposed to happen. On my friends it remains =A2*3 Does anybody know what could be causing this or how i can fix it? Thanks |
#2
|
|||
|
|||
It sounds like their calculations settings are set to manual.
Tools--Options, Calculations tab. ******************* ~Anne Troy www.OfficeArticles.com "wannaboardx" wrote in message ... In my copy of excel 2003 when i copy a formula like =A2*3 one cell below, it changes to =A3*3 This is what is supposed to happen. On my friends it remains =A2*3 Does anybody know what could be causing this or how i can fix it? Thanks |
#3
|
|||
|
|||
The calculation setting didn't seem to affect the adjustment copying
relative cell references in my version of xl2003. Did you get a different results? -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... It sounds like their calculations settings are set to manual. Tools--Options, Calculations tab. ******************* ~Anne Troy www.OfficeArticles.com "wannaboardx" wrote in message ... In my copy of excel 2003 when i copy a formula like =A2*3 one cell below, it changes to =A3*3 This is what is supposed to happen. On my friends it remains =A2*3 Does anybody know what could be causing this or how i can fix it? Thanks |
#4
|
|||
|
|||
Nope. I didn't test. My bad.
"Tom Ogilvy" wrote in message ... The calculation setting didn't seem to affect the adjustment copying relative cell references in my version of xl2003. Did you get a different results? -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... It sounds like their calculations settings are set to manual. Tools--Options, Calculations tab. ******************* ~Anne Troy www.OfficeArticles.com "wannaboardx" wrote in message ... In my copy of excel 2003 when i copy a formula like =A2*3 one cell below, it changes to =A3*3 This is what is supposed to happen. On my friends it remains =A2*3 Does anybody know what could be causing this or how i can fix it? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
how do i automatically insert the current author's name in a cell. | Excel Worksheet Functions |