Prev: How do I change the links in Excel at one batch?
Next: How to run a macro automatically when the file is opened?
From: LunaMoon on 23 Apr 2010 19:18
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!
 | 
Pages: 1
Prev: How do I change the links in Excel at one batch?
Next: How to run a macro automatically when the file is opened?