Referenced cell does not automatically update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Nope. I didn't test. My bad.

Tom Ogilvy said:
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?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Creating Excel Formula 4
Adjusting formulas by copying across cells w/o changing the refere 6
Vlookup with If condition 1
Avoiding redundant calculations 7
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
formula cell format change 3
Concatenation help 8
using a cell's reference to return a value. 3

Back
Top