Hi, I want to have an excel workbook with several worksheets and two user groups, where group a can access and edit everything and group b can access and edit only one sheet as well as certain columns in one other sheet.

The workbook is on a sharepoint server where all users (some of them external) have access.

At first this is fairly trivial with password protection. But it seems group b is able to see everything while someone from group a has entered her/his password, does some editing, and until the user from group a hides the sheets again.

How do I fix that, please?