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?