Weird Excel problem
Author
Discussion

puggit

Original Poster:

49,832 posts

279 months

Wednesday 18th April 2007
quotequote all
My boss has sent out a spreadsheet which has a strange feature.

If I go to cell A1 and input '1' and cell A2 and input '2', then go to cell A3 and input '=A1+A2' it correctly give the cell a value of '3'. If the figures in A1 and A2 are then changed, the value in A3 does not change!?

Any ideas?

Raify

6,556 posts

279 months

Wednesday 18th April 2007
quotequote all
sounds like calculating is set to manual, instead of automatic.

Raify

6,556 posts

279 months

Wednesday 18th April 2007
quotequote all
Tools > Options > check the radio button next to Automatic calculation

puggit

Original Poster:

49,832 posts

279 months

Wednesday 18th April 2007
quotequote all
thumbup

Ta

Raify

6,556 posts

279 months

Wednesday 18th April 2007
quotequote all
Welcome! beer

The Walrus

1,857 posts

236 months

Wednesday 18th April 2007
quotequote all
Or press F9 if you are lazy have you checked that he has not turned it off for a reason ???