[ms office - 2003] Excel Security

[storkyIV]

Hi all,

 

I have an annoying problem that I have been trying to find a work around for the past few hours!

 

I have a master excel spreadsheet with individual spreadsheets linking to the master.

The problem is, I don't want users having access to viewing the master sheet, just their own faculty one.

 

If I lock the master to stop public viewing, the individual sheets can't update unless the user enters the password for the master.

 

Is there something silly that I have missed, or is there an easier way to do this?

 

Many thanks in advance.