<Application.ScreenUpdating = True ' does nothing
Activeworkbook.Precisionasdisplayed = True ' does nothing

Plus the fact that you're posting in .Programming makes me think you fire
calculations or enter formulas from VBA.
If so (or if something else happens in VBA), post your code or what you do
in the immediate window


--
Kind regards,

Niek Otten

"Brian Matlack"
wrote in message
news:Brian.Matlack.20aj2m_1135001405.1356@excelfor um-nospam.com...

Hi!
I have a formula that simply refers to a cell with a date. Most of the
time it works fine but on occation it refuses to update and I cannot
seem to find the logic. The base cell (A1) says Dec-05 the formula cell
(B1) =A1 says Nov-05. How can this be?

F9 manual Calc does not fix it nor does Tools Options Manual
Calculation
Application.ScreenUpdating = True ' does nothing
Activeworkbook.Precisionasdisplayed = True ' does nothing

The only way I have found to fix it is to edit directly into the cell
or formula bar. If I select the cell and hit F2 and enter then it will
read OK.

Please help if you can Thanks


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=494580