Dave - that sounded simple enough, but I can't get it to work.

I've named the cells I need links to, and for a portion of the named linked
cells it works. For the other half of named linked cells it doesn't - it is
taking the data from i.e. A70, even though five rows have been added on top
and it should now be referencing A75. I named the cells so I don't know what
the issue is.

Do you have any suggestions?

"Dave Peterson" wrote:

If you name the cell (insert|name|define), then the link will follow that named
cell--no matter where it is.

Sarah wrote:

I have links set up between a number of complex worksheets and workbooks in
excel 2003. However, I find that when I insert rows or columns in the sheet
to which I'm linking, it throws off the value in the linking sheet.

In workbook #1, I have link <=[workbook #2.xls]worksheet!$B$10

If I go to Workbook #2 and insert a row or rows above row 10, the value
shown in Workbook #1 changes, because it is showing the new value in cell
B10. However, what I want to be able to do is link to the particular cell in
workbook #2 - so that I could insert and delete rows/columns, and the info in
that particular cell would still be the source of the link.

Thanks,
Sarah

--

Dave Peterson