Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link changes in destination workbook
I have 2 workbooks linked - when I insert a row in the source workbook the
destination workbook does not update (even when I do an update). ex. cell A2 in workbook 1 is linked to show up in cell c5 in workbook 2 but I need to insert a row above A2 so A2 becomes A3 but then in workbook 2 = cell c5 still points to A2 instead of updating to A3. is there a way around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link changes in destination workbook
"confused" wrote: I have 2 workbooks linked - when I insert a row in the source workbook the destination workbook does not update (even when I do an update). ex. cell A2 in workbook 1 is linked to show up in cell c5 in workbook 2 but I need to insert a row above A2 so A2 becomes A3 but then in workbook 2 = cell c5 still points to A2 instead of updating to A3. is there a way around this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link changes in destination workbook
I am having the same issue. I have a summary workbook that has links to two
other workbooks. It appears that the link to the second destination does not update when adding rowns. Has anyone else encountered this? I sure would appreciate some feed back. "Cindy" wrote: "confused" wrote: I have 2 workbooks linked - when I insert a row in the source workbook the destination workbook does not update (even when I do an update). ex. cell A2 in workbook 1 is linked to show up in cell c5 in workbook 2 but I need to insert a row above A2 so A2 becomes A3 but then in workbook 2 = cell c5 still points to A2 instead of updating to A3. is there a way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change link path when open destination file | Excel Worksheet Functions | |||
Insert row treated differently depending on link destination | Excel Worksheet Functions | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Update link without openning the source/destination files | Excel Worksheet Functions | |||
Destination workbook formulae become #VALUE! | Excel Discussion (Misc queries) |