Not calculating =today()

[meledward23]

So, simple formula,
=today()

All other formulas are calculating automatically (yes formulas - automatic is on).

Is there anything else that can stop this from working?
If I select the cell and hit enter, nothing happens.
If I select the cell, click on the formula, and hit enter, it updates properly.

There is no VBA on this tab.
There is a chance some VBA somewhere else is causing this. Just wanted to make sure I am not missing some other possible explanation.

Thanks,

 

[jasonb75]

That is a volatile function, if you are doing something that is causing other formulas to update then that should also update.

The only time it would remain unchanged would be if you had used a circular reference to prevent it from doing so (unless you have only shown us part of your formula, this is not happening to you).

 

[meledward23]

Thanks, I have the same conclusion. There is no other part to this formula, it just sets the date in a single cell for when you print the sheet so there is todays date. I was just making sure there is no turn on manual calculations for single cell as that is what it feels like is happening, and since the rest of this Tab (worksheet) automatically updates its formulas, I am puzzled.
Thanks.

 

[jasonb75]

Have you tried copying the sheet (not the cells) to a blank workbook to see if it works there?

Right click the sheet name, then 'Move or Copy' etc.