Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows in multiple workbooks
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: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=495173 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows in multiple workbooks
safest 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 "50pingviner" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=495173 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows in multiple workbooks
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: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=495173 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
vlookup multiple text rows | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
linking to multiple workbooks | Excel Discussion (Misc queries) | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel |