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"
wrote in message
news:Brian.Matlack.20armz_1135012501.2375@excelfor um-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