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.