Link changes in destination workbook

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

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?
 
confused said:
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?
Click to expand...
 
confused said:
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?
Click to expand...
 
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.
 
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.
 
Back
Top