Need help with sorting and linking

[Izzy]

I have a master workbook on a single sheet that contains all of my data.


I have another workbook that contains individual sheets dividing the
data on my master list into subgroups. This workbook is linked up with
the master workbook.

I notice that if I sort the data on my master list in a particular
order, the cell references on my linked workbook do not change, so that
I'm ending up with wrong data on the linked workbook.

I need the cell references to be dynamic rather than static so that if
I do sorting on one workbook, the cell references in the linked
workbook change to reflect the same data which is now in a different
cell.

Someone told me to remove the "$" symbol from all the links, but this
is not working because (I think) I have several workbooks all linked
together. So the last link is refering to another link, which is
refering to another link, etc...

I hope this is not too difficult to understand. Feel free to email me.

 

[Debra Dalgleish]

The links are to a cell, not to the data in a cell. So, when you sort
the data in the master list, the references will continue to point to
the same cell.

Perhaps you could leave the master list unsorted, and create another
list in the master workbook where you link to the master list, and sort
there. Then, none of the other linked references would be disrupted.

 

[Izzy]

I figured out whats going wrong, but I haven't figured out how to fi
the problem.

The problem is not with the chain of links, nor is it with dependan
links. All the links are going in one direction, they are not skippin
over each other (circular links) there should be no dependant errors
and there aren't.

If I link identical worksheets and then sort the first one, all th
linked worksheets update perfectly. I tried it with 20 linked workbook
and the links don't fail. So the links aren't the problem.

What's happening is that I am sorting the first workbook, then pastin
a block of links over to a blank workbook, and then sorting the firs
workbook back to it's original order. When I do this, the links on th
second workbook do not update and suddenly become static, regardless o
syntax.

So, if the dependant workbook is not identical to the workbook bein
sorted, then the links default to being absolute.

I can't understand why this isn't working