Update linked Microsoft Excel workbook without allowing users to view the master 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??

Update linked Microsoft Excel workbook without allowing users to view the master workbook?
First of all Linking the workbooks is not what you want....first create a Master Workbook, then give each department their own workbooks Name the main workbook as Master and the individual ones as the deptartment that they represent for example Human Resources. In the Master Workbook name the first sheet the same Human Resources in this case. In cell A1 of the Master type in the formula


='[Human Resource.xls]Sheet1'!A1 Name sheet 2 in the Master as the name of the next department....Accounting for example...='[Accounting.xls]Sheet1'!A1 use the pull handle to pull the formula across and down the Master Worksheets as needed then when they enter in information the next time you open the Master it will all update....now you can do one of two things store them both on the server but make he Master Hidden and restricted to your login give them access to only their department workbooks using their logon access ask IT about helping with that and viola your done. No linking....formulas work better for this.

sliders