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

Gregor,

Surely the solution is to find out why they work so well together, and fix
that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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

But sheet A gets data continuously from sheet B (sheet B is link to an
external database). When A and B is running in separate Excel
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 B
and update links in A?

Thanx in advance for any help!


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

Bob Phillips wrote:

Surely the solution is to find out why they work so well together
and fix that.

That is not an option, one of the macros are written by an externa
consultant, and the code is password protectet. When I run the tw
sheets i same Excel appl., Excel just crashes without any erro
message. So troubleshooting becomes almost impossible

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

Passwords are easy to crack!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gerok " wrote in message
...
Bob Phillips wrote:

Surely the solution is to find out why they work so well together,
and fix that.

That is not an option, one of the macros are written by an external
consultant, and the code is password protectet. When I run the two
sheets i same Excel appl., Excel just crashes without any error
message. So troubleshooting becomes almost impossible.


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

Bob Phillips wrote:
Passwords are easy to crack!


That might be, but I don't think that will solve my problem. This shee
has rather complicated macros, designed for exchanging data from
database. So I rather not mess with that... :

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