Does anybody know why these two Excel files must be open in the sameprocess?

[LunaMoon]

Hi all,

I am doing the following sequence of operations all the time:

1. Open up an Excel 2003 sheet A;
2. Click a button and run a macro in that Excel sheet;
3. After it finishes running, open up another Excel 2003 sheet B in
the same Excel session/process;
4. Press F9 to do calculation/update the sheet, and save the Sheet B.

B has a lot links linked to A...
-----------------

Sometimes, if I update file A, save it, and close it before opening B,
(i.e. now the file B and A are not in the same Excel session/
process) , B's update will fail (i.e. B's links will not get updated,
and numbers not refreshed...)

Anybody knows why?

Thanks!

 

[joel]

I would need to see the macro(s). Usually these problems are due to th
focus being on the wrong workbook or worksheet while the macro i
running. Replacing in the macro Activeworkbook with Thisworkbook wil
help and specifying in the macro(s) the actual sheet names instead o
Activesheet.

The focus is changed when the following options are performed and ca
cause problems inside macros

1) Open a workbook
2) Adding a new workbook
3) Adding a new worksheet.