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
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
Windows 98 + Office Pro 97