3445245 - All workbook options are greyed out while using SAC Excel add-in

All workbook options are greyed out in SAC Excel add-in after logged into the system, as per screen shot below:

It might happen:

• For one specific user or all of them
• After sharing a file from one user to another
• For some workbooks and not all of them

• SAP Analytics Cloud, add-in for Microsoft Office
• SAP Analytics Cloud

1. Open a workbook in SAC Excel Add-In
2. Log into the required tenant
3. All options (refresh, add table, remove table and so on...) will be greyed out

Missing permissions for the affected users

There are some points to be considered when an user or a group of users is facing missing permissions issues, such as:

1. If the affected user cannot see any options in SAC Excel Add-in after logged into the system, most likely this user has been assigned a ROLE that has only read rights defined in "Add-in Workbook" permission.
   i.e.: VIEWER RIGHTS only. Please see the screenshot below as an example:
   
   
   
   Assign permissions Create and Update in order to solve the issue.
   
   This permission can be found in SAP Analytics Cloud page -> go to "Security" option in the left panel -> "Users" (to check other users - admin rights might be required for this option) or "Roles" (to check your own roles) and this option will be inside "BI Content...".
   
   

2. If the affected user can see some workbooks and cannot see others, there are 2 possibilities for this situation:

   •    It’s a Legacy workbook: All the workbooks created before the release of Design/View feature are considered as legacy workbook and all the users have full access to such workbooks
   •    Designer have provided full access to the workbook to all other users
   
   See screen shot below for this option:

   

• SAP Help - Permissions for the add-in

missing, permission, SAC, Excel, Add-in, greyed out, grayed out, unavailable, workbook, Role, read, create, updates, rights, legacy workbook, designer , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions