auto calculate not working

  • Thread starter Thread starter jsimpple
  • Start date Start date
J

jsimpple

I'm using Excel 97. Workbook is setted to Auto calculation in both
Option and Auto_Open VBA. However, the formula (eg. =today()-1) does
not work even the Auto_open set the file to auto calculate and
Calculate. And when press F9, it still doesn't calculate. It also
doesn't work when I close and reopen the file.
The calculation only works when I click into the cell (i.e F2) and
enter.
Any advice?
 
One possibility could be in options-calculation is set to
manual. Try changing it to automatic.
 
Back
Top