Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Workbooks - adding lines and keeping links
I'm having a problem with linking workbooks and keeping cells linked to their
correct cells when adding lines. For example, in one workbook (linked) I have a cell linked to A4 in another workbook (source). After I've created the link, I save and close both workbooks. Let's say later I open the source workbook, add a line that shifts all the data down a row, save and close. When I open the linked workbook, my linked cell is still pulling from A4 instead of A5. Is there a way to add lines in source workbooks and keep links in linked workbooks without them both be open at the same time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when adding row in linked workbooks, data in receiver loses a row | Excel Worksheet Functions | |||
Linked workbooks, changing links | Excel Worksheet Functions | |||
Keeping Links Consistent Between Workbooks | Excel Discussion (Misc queries) | |||
Macro for Adding Lines to Linked Spreadsheets | Excel Worksheet Functions | |||
Keeping Cells linked | Excel Discussion (Misc queries) |