Adding passwords to different sheets in Excel within teams

Question

I have a joint team who use Excel, there is a sheet for everyone to add their details on, is there a way that there could be passwords for each sheet, i.e. for each user in their own space. So that it can still be read by all but only edited on the sheet by the individual and or the teams owner?

nikolinode · Answer

Maggie68&nbsp;&nbsp;* Knowing the Excel version and operating system would also be an advantage.&nbsp;Collaborate on Excel workbooks at the same time with co-authoringhttps://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-us&amp;rs=en-us&amp;ad=us&nbsp;About the shared workbook featurehttps://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534?ui=en-us&amp;rs=en-us&amp;ad=us&nbsp;I would be happy to know if I could help.&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.&nbsp;

Forum Discussion

Adding passwords to different sheets in Excel within teams

1 Reply

Resources