Ashleigh,

Have you tried forcing a calc?

Application.CalculateFull

HTH,
Bernie
MS Excel MVP


"Ashleigh Gardner" <Ashleigh wrote in
message ...
I have an excel application with two workbooks. I have written a VBA
macro
in workbook 1 that includes a .open command to open workbook 2. Workbook
2
successfully opens, however, none of the array formulas residing in
workbook
2 are updated (they all seem to default to a zero value). I have tried
changing the screenupdating and calculation properties. Any suggestions?