Jedi Master
Board Regular
- Joined
- Jun 10, 2024
- Messages
- 70
- Office Version
- 365
- Platform
- Windows
Hello, I have a workbook with about 75 sheets in it that I have all but 4 hidden and structure locked. I need people that shouldnt see the info on the hidden sheets to input info into the 4 they can see. I also need people that should see all sheets to access the workbook without having to unlock and unhide all the time. I tried creating a new workbook with copies of the sheets they need to see that are normally hidden, but the linked books are not retaining their values in the sheets. I know it has something to do with where they are stored. The large workbook is stored in sharepoint, the linked workbook with the hidden sheets is stored in my one drive and accessed via a share link. Is there a way to make this work or a better way to accomplish this?
