I have been Looking all over, but I can't find an answer to this challenge. We currently have different files for different Departments, so pulling a summary report is not possible without Opening each one of These files to update my summary page. Here my Question: I would like to combine alls these single files into one, is there a way to create a workbook with several work Sheets (A, B, C....) and then to protect them in a way, that only User A can see & Access Sheet A, User B can only see & Access Sheet B, User C can only see & Access Sheet C. Important is that User A can fully Access Sheet A but has no Access to the other Sheets, not even to look at the data on them.
Of Course Administrator X should have Access to all Sheets. Also, could then a User have Access to several Sheets, eg. User D has Access to sheet D and E?
Is that actually possible or am I expecting too much from Excel??