Hi All

I have two spreadsheets which are linked together. Spreadsheet a is linked
to b so that in spreadsheet b it pulls in the cells B6:B17 from spreadsheet a.

Unfortunately I need it to pull in b5:b16 so what I'm trying to do is to
delete a row in spreadsheet a. But when I do that the cell reference in
spreadsheet b automatically changes. Is there anyway to stop it automatically
changing?

Reason I;m not just changing the reference is that there are actually about
26 spreadsheets that are like spreadsheet a which are linked to b. And this
would be the quickest way of changing them all.

I hope this is possible

Many Thanks

--
Adam
-----------
Windows 98 + Office Pro 97