Passwording a linked spreadsheet

[Adam]

Hi All,

I've been asked to create a series of spreadsheets that link into one
master spreadsheet.

Each spreadsheet will have a summary column where the users will input
what they want to see on the master spreadsheet.

The master spreadsheet will then only show that field.

However I want users to have access to the master spreadsheet but only
selected personnel can have access to all of the seperate spreadsheets.

I would like to password each of these files with a different password.

Only problem is that when your in the master spreadsheet and you update
the links, it asks for the password of the password protected series of
spreadsheets.

Does anyone know how I can get around this?

I know I've explained this badly!

Adam

 

[Dave Peterson]

I think I would create a separate workbook that opens all the subordinate files
using a macro. You can supply each password in that code and you can open them
readonly.

Then open the master workbook. Since the subordinate workbooks are open, the
links will refresh imediately, too.