Is there any functionality to lock a specific sheet. I dont think there is but this would really help for the situations explained below. There are two scenarios:
We have a master sheet, where all product information is pooled. there are 100 different columns and hundreds of rows. One team is responsible for inputting the first 5 columns of data and populating all the rows for that data.
Team 2 are responsible for filling in the information for the next 10 columns on all rows
Team 3 are responsible for the next 15 columns
Team 4 are responsible for the next 5 columns
Now we want to make sure that only each specific team can update their columns so that the other teams do not edit their data by mistake. Therefore we use reports that give each team those base 5 columns and then the columns that relate to them.
However there is no way to stop them going into the main sheet and editing all the data. One could suggest locking cells but this doesnt work in the fact that you have multiple teams editing different data. Also you have to give them access to the sheet for them to be able to view the report.
HR have a very sensitive document for bonus review. It lists all pay for all employees that is split out by managers. Each manager has to fill in their suggested bonus for each member of their team. The ideal would be to have a master sheet that could be locked and then run reports for each manager that listed their team members as then this would in turn update the master. However because you cant restrict the master what you have to do is have different sheets for each manager and then pool these togetehr in 1 report to have the full picture. This is clunky and has issues when you want to update the format of the sheets.
Sorry for the long post but its an issue that has been bugging me.
Any help would be amazing.