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.