auto calculate not working

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?
 
T

TK Rai

One possibility could be in options-calculation is set to
manual. Try changing it to automatic.
 

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

Calculate message 1
Cells Not Calculating - Calc Option Selected 2
Cell showing formula instead of date 6
Auto Calculate 1
Automatic calculation is not working 4
Calculate message 3
F9, Shift+F9, Ctrl+Alt+F9 etc 3
Forumlas Aren't Auto Recalculating 1

Top