Forum Discussion
reprised
Jul 08, 2020Copper Contributor
You don't have permission to add a Form to this shared workbook.
Hi, I am trying to create a Form for Excel in onedrive but I am experiencing the error message: You don't have permission to add a Form to this shared workbook. The folder that i'm trying to ...
MikePalomares
May 03, 2021Copper Contributor
this might be an old issue, but we are experiencing as well
Try checking on your O365 Group linked to the sharepoint site, and check if the group has permissions on the library and if the users are members of the group
We have found out that when the permission of the linked group to the library are removed
or when the user is removed from the linked group, then you receive that access error.
My theory is that Forms is trying to access the Excel file by using the O365 Linked group instead of the actual user account thus, getting the access error.
Try checking on your O365 Group linked to the sharepoint site, and check if the group has permissions on the library and if the users are members of the group
We have found out that when the permission of the linked group to the library are removed
or when the user is removed from the linked group, then you receive that access error.
My theory is that Forms is trying to access the Excel file by using the O365 Linked group instead of the actual user account thus, getting the access error.
Aylarja
Oct 13, 2022Copper Contributor
MikePalomares, your theory seems to be correct. I had this exact same issue, and in my case the end user was assigned a license in MS Forms (and could create forms directly in MS Forms), and was a member of a SharePoint group which had contribute permissions in the document library. However, that person did not belong to the Microsoft 365 group associated with the site. When I added him to the M365 group which had limited permissions on the site, he was able to create an MS Form starting from the SharePoint library. I think your theory is sound - it makes sense that Microsoft's connectors are using M365 groups and not classic SharePoint permissions groups.