Symptom
- The Excel add-in "Save" function does not respect folder-level write permissions set to view-only.
- When a user saves a shared workbook via the Excel add-in without changing the destination, the original file is overwritten even if the target folder is configured as view-only.
Environment
Product: SAP Analytics Cloud, add-in for Microsoft Office Application
Reproducing the Issue
- Sign in with a user who has Create and Update permissions for Add-in Workbooks.
- Ensure a shared folder is configured as View-only (no Create/Update) for this user.
- Open a workbook from that folder using the Excel add-in.
- Make any change in the workbook.
- Click Save or Save As without changing the destination folder.
- Observe that the shared file is overwritten and/or a new workbook can be saved in the view-only folder.
Cause
A role with Create/Manage permissions on Private/Public Files is assigned to the user.
Resolution
Adjusting the role permission to ensure no Create/Manage permission on files are provided.
See Also
Keywords
sac excel add-in, save, save as, folder permissions, view-only, custom access, overwrite, add-in workbook, create permission, update permission, file permissions, repository, workbook, sac web, permission validation , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , How To
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public