Formulas don't update?

[Brian Matlack]

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

F9 manual Calc does not fix it nor does Tools Options Manua
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 cel
or formula bar. If I select the cell and hit F2 and enter then it wil
read OK.

Please help if you can Thank

 

[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" <[email protected]>
wrote in message
news:[email protected]...

 

[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" <[email protected]>
wrote in message
news:[email protected]...

 

[Brian Matlack]

Niek:
Rebuilding the dependancy tree did it. (CTRL+ALT+SHIFT+F9) Thanks fo
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" <[email protected]>
wrote in message
news:[email protected]...