How do you link cells in different Workbooks in Excel?

I'm linking data on one worksheet to another in the same workbook. When I alter the worksheet where the original data is entered (ie: sort based on changing numbers such as sales per representative), it alters the linked data in the other worksheet ie: the sales rep names are now no longer aligned with the correct sales numbers. I've used a function utilizing $ $ to bracket the destination cells so that I can sort that page but the original source worksheet cannot be sorted with out messing up the data on the linked worksheet. How do I keep that from happening? Thanks!

Dear Sir,

I would like to learn a to z about link command in excel

would you please help me in this regard

thanks & regards,
m.imad

I want to make a link from one area to another in the same worksheet but in reverse order

Is it possible to use relative pathing to link two workbooks in the same directory?

'.\[book1.xls]sheet1'!$a$1
instead of c:\temp\[book1.xls]sheet1'!$a$1

I need to send several link workbooks to someone who is on a different file server
Thanks

Hi,

I have built a "master database" which houses everyone who works for my company. The data is broken down so employees are grouped together by the branch they work at. I have also created a secondary database that is unique to the individual and not the branch. For example, the master database shows everyone who works at Location A, Location B, Location C etc and from that Person A at Location A has their own workbook linked back to the master database (EG A2). This means if i alter, for example person A's contact number in the master database, his personal file will automatically update. My problem is that if someone joins my company at Location A, once i "insert" a new row to house the new persons data, Person A's individual link now picks up whatever is in A2 and is not locked into the data assigned to Person A. How can i secure or lock this link so if i need to add people to the master database, all of my satellite databases for each individual is not thrown off by any new arrival?

Thanks