Aug 04 2021 05:59 PM
We have Office 365 and we collaborate on Excel workbooks at the same time with co-authoring. To prevent accidental errors, I am trying to set permissions to different users to access different spreadsheets within the same Excel workbook. For example, user A will be able to access 'Sheet1' and 'Sheet2' spreadsheets but not 'Sheet3' spreadsheet. User B will be able to access 'Sheet1' and 'Sheet3' spreadsheets but not 'Sheet2'. Would greatly appreciate any advice on how to achieve this function, thank you!