software

Hi,

I am working in a workbook that have external references to another
workbook.
If I insert a row in the workbook, which is being linked to, it messes
up the links.

How can I make the workbook with the links automatically generate a row
with links, when a row is generated in the other workbook?

Thx. Lars--
50pingviner
------------------------------------------------------------------------
50pingviner's Profile: www.excelforum.com/member.php...oamp;userid=29298
View this thread: www.excelforum.com/showthread...hreadid=495173safest way is to have the linking worksheet link to NAMED RANGES, not
addresses.
2nd safest way is to have all related workbooks opened at the same time.
Then, when an insertion is made, the references adjust.
Bob Umlas
Excel MVP

quot;50pingvinerquot; gt;
wrote in message
...
gt;
gt; Hi,
gt;
gt; I am working in a workbook that have external references to another
gt; workbook.
gt; If I insert a row in the workbook, which is being linked to, it messes
gt; up the links.
gt;
gt; How can I make the workbook with the links automatically generate a row
gt; with links, when a row is generated in the other workbook?
gt;
gt; Thx. Lars
gt;
gt;
gt; --
gt; 50pingviner
gt; ------------------------------------------------------------------------
gt; 50pingviner's Profile:
www.excelforum.com/member.php...oamp;userid=29298
gt; View this thread: www.excelforum.com/showthread...hreadid=495173
gt;

Thx.. but I would like the other sheet to automatically make a similar
row, so the two sheets match. It should be possible with a macro, but I
cant make it do it.

But thx. for the fast reply.--
50pingviner
------------------------------------------------------------------------
50pingviner's Profile: www.excelforum.com/member.php...oamp;userid=29298
View this thread: www.excelforum.com/showthread...hreadid=495173