Forum Discussion

Laura_Dez's avatar
Laura_Dez
Copper Contributor
Jun 11, 2024

Tab Privacy in Excel

Hi, hoping you might be able to help with this query as I cannot find an answer anywhere.

I need to have multiple tabs in the same spreadsheet for example, called Claire, Des, Laura, Malcolm, Martin, Jackie but I need to make each tab private to all users except to that persons own tab and the main admin who can access them all. Is this possible?

I know you can protect information within each tab from being altered but I need each tab not to been seen by specific users.

Thanks in advance,
Laura

Excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 12, 2024

    Laura_Dez Excel protection was never intended to keep people from accessing sensitive information. If you do not want people to access certain information in a file, don't include that information.

     

    What I would suggest you to do:

    1. Create one workbook for everyone
    2. Create a dedicated Sharepoint or OneDrive location for this
    3. In that location, add a subfolder for each person
    4. Allow access to that folder to only that person (and yourself)
    5. Send everyone their personal link
    6. Save a spreadsheet with just the tab for that person in his/her folder
    7. Open a blank workbook, use Data, Get Data, From File, From Folder to gather the data from everyone into one master workbook only you have access to.

Resources