...workbook? We have a master workbook containing multiple worksheets. There is one worksheet for each department in the company. Each worksheet is comprised of confidential salary information for the new hires coming into that department.

We have created a linked workbook for each department connecting to that department's worksheet in the master.

The problem we are running into is the users can't seem to update their specific linked workbook without having Read access to the master. We do not want the users to be able to see all of the worksheets in the master. How do we set it up so the users can update their workbooks with the most up-to-date information on the master without letting the users see the master????? Pasword protecting the file carries over to the linked workbooks, so that won't work.

Any suggestions??