We have a strange behaviour of excel with files on SharePoint. The situation is as following:
- User has read-only rights on SharePoint
- Folder (also read-only) contains Excel file
- Excel file is set to edit rights for user via "grant access"
Editing the Excel file in the browser works as Excel Online respects the individual permissions on the file. Excel Desktop app refuses to save the file because "the folder is write protected".
Does Excel Desktop not recognize the individual permissions on a file or why is this error happening?