Formulas don't update?

[Brian Matlack]

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

[Niek Otten]

<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" <Brian.Matlack.20aj2m_1135001405.1356@excelforum-nospam.com>
wrote in message
news:Brian.Matlack.20aj2m_1135001405.1356@excelforum-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
>

[Brian Matlack]

Niek:
Actually I am pretty much a novice when it comes to VBA. All I do is try to stick to simple stuff like copying ranges navigating the sheet and allowing for user input of data. All of the work is done with formulas.
The problem I am having may have nothing to do with VBA. I do copy and paste a great many formulas in VBA on this spreadsheet both in copy selection and paste special values [ Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False] and in copying a range to a range [Range("list3").Value = Range("list2").Value Range("list5").Value = Range("list4").Value]
The formulas that are causing me problems are not being copied and pasted they are stationary cells no columns or rows are added or deleted. I just don't know what would cause a formula to update and sometimes not even when you do a manual calc to force it to update.
I know this is pretty vague and I appoligize I hope you can help stear me in the right direction to look for answers
Thanks for your help!!

[Niek Otten]

Hi Brian,

Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 (only last few
versions of Excel)
Almost the equivalent of that (with a one-worksheet workbook) is to search
and replace all "=" with"="

Be aware that the Calculation mode is an Excel-wide setting; if you had
another workbook open when opening the problem workbook, the setting may not
be what you saved it with.
Other problems with recalculation can occur with User Defined Functions
(which I don't suppose you have) and with older versions of Excel, notably
Excel 97 version 5.0a

--
Kind regards,

Niek Otten

"Brian Matlack" <Brian.Matlack.20armz_1135012501.2375@excelforum-nospam.com>
wrote in message
news:Brian.Matlack.20armz_1135012501.2375@excelforum-nospam.com...
>
> Niek:
> Actually I am pretty much a novice when it comes to VBA. All I do is
> try to stick to simple stuff like copying ranges navigating the sheet
> and allowing for user input of data. All of the work is done with
> formulas.
> The problem I am having may have nothing to do with VBA. I do copy and
> paste a great many formulas in VBA on this spreadsheet both in copy
> selection and paste special values [ Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _ :=False, Transpose:=False] and in copying a range to a
> range [Range("list3").Value = Range("list2").Value
> Range("list5").Value = Range("list4").Value]
> The formulas that are causing me problems are not being copied and
> pasted they are stationary cells no columns or rows are added or
> deleted. I just don't know what would cause a formula to update and
> sometimes not even when you do a manual calc to force it to update.
> I know this is pretty vague and I appoligize I hope you can help stear
> me in the right direction to look for answers
> Thanks for your help!!
>
>
> --
> 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
>

[Brian Matlack]

Niek:
Rebuilding the dependancy tree did it. (CTRL+ALT+SHIFT+F9) Thanks for the help!!

[Niek Otten]

Thanks for the feedback. I'm always a bit hesitant to advise this, but there
are a surprising number of occasions where it seems to solve a problem. So
your response is encouraging me to suggest using this, although I realize
that often something else is wrong.

--
Kind regards,

Niek Otten

"Brian Matlack" <Brian.Matlack.20ceny_1135089002.9976@excelforum-nospam.com>
wrote in message
news:Brian.Matlack.20ceny_1135089002.9976@excelforum-nospam.com...
>
> Niek:
> Rebuilding the dependancy tree did it. (CTRL+ALT+SHIFT+F9) Thanks for
> the help!!
>
>
> --
> 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
>