Links in Excel

  • Thread starter Thread starter herb
  • Start date Start date
H

herb

I am using Excel and OSX.

I can link from one workbook to another. But if I change the location
of a link (for example, adding a row), I find that the object link is
still looking for the old location.

That is, if the subject of the link is in cell B5, and I add a row to
the workbook so to that the subject of the link is now in cell B6, I
find that the object of the link is still look for whatever is in B5.


Thanks
 
Herb,

This does occur whenever you change the file that is linked to, without
having the file liking to it opened as well...

You might want to open the linking files together whenever you plan
to make changes like this, or you might want to change the structure
of your worksheet so that the normal operation that would need you
to insert a line, would for example just be added to the bottom of the
worksheet, so it won't mess up the links...

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl
 
I can link from one workbook to another. But if I change the location
of a link (for example, adding a row), I find that the object link is
still looking for the old location.

That is, if the subject of the link is in cell B5, and I add a row to
the workbook so to that the subject of the link is now in cell B6, I
find that the object of the link is still look for whatever is in B5.
Click to expand...

This shouldn't happen when both workbooks are open. Are both workbooks open?

You could avoid this by naming the cells you're using in the link references.
 
Back
Top