Access to resources, such as Workbooks, Data, and APIs are granted to Access Groups. You can grant that access by setting Workbook Permissions.
Every time a new workbook is created the access need to be granted.
Granting Workbook Permission
- Go to the “Workbook Permission” tab,
- Highlight your solution or chosen workbook in the Workbooks and Pages field,
- Click on the “Edit” button on the right-hand side of Explicit Permission,
- Click the “Add” button in the Permissions pop-up,
- Select “Admin” in the access group selector and click OK,
- Click “Save and publish”.