I have to worksheets, each with a lot of macros. The two sheets don'
work so well together, so it necessary to run them in separate Exce
applications - then it does not crash all the time.

But sheet A gets data continuously from sheet B (sheet B is link to a
external database). When A and B is running in separate Exce
applications the automatic linking of data between them does not work.

Can this be fixed without macros?

If not, how can i, in a marcro run from A, select application B, save
and update links in A?

Thanx in advance for any help

--
Message posted from http://www.ExcelForum.com