Help with referencing please

  • Thread starter Thread starter clueless_05
  • Start date Start date
C

clueless_05

I'm working on a spreadsheet which has calculations in one sheet whic
depend on values on another. I'm pretty sure the references are right
as everything was working fine earlier - when I changed the values i
one sheet the other sheet updated automatcially. However, now when
change the values in one sheet the values in the other do not chang
automatically but do update when I click enter after the formula in th
"insert function" bit at the top.

Have I disabled something accidently maybe?

And sorry for being crap at describing problems
 
it may be that you have set your 'calc' option to manual

pressing F9 will force a recalc or the method you described

to check if you have manual or automatic calc then clic
TOOLS/OPTIONS/CALCULATION and make sure it is set to Automatic

Hope that solves it

Mar
 
Back
Top