calculation

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

I have a spreadsheet which runs a number of calculations using vba.

For example, if I have a value in A1 and a value in A2, and a formul
in A3: sum(a1+a2). if I alter A1 then it doesnt automatically updat
the sum in A3.
This used to work, but I now have to force the calc by pressing F9.

Any ideas what has happened? and how to fix it ?

Thanks
Scott
 
It could be that you've turned auto calculation off -- in tools/options.
Possibly, there is something in one of your macros that does this.

Art
 
Back
Top