Jan 21 2020
09:38 AM
- last edited on
Aug 06 2023
05:01 PM
by
TechCommunityAP
Jan 21 2020
09:38 AM
- last edited on
Aug 06 2023
05:01 PM
by
TechCommunityAP
We have a user that is receiving the following error:
"You don't have permission to add a Form to this shared workbook.
Create your own Excel workbook and try again."
This happens when the user creates their own Excel workbook in a SharePoint site that they own/administer. They are opening the workbook in the Excel web app and choosing Insert >> Forms >> New Form
It's occurring with every Excel workbook.
They have shared the file with me and I am experiencing the same error. It's not happening on files I create, though.
Does anyone have any insight into this error?
Jan 24 2020 07:26 AM
@lrc5333 We having the same issue, we have made sure document is checked in etc.
Made sure all mandatory properties are filled in.
Tried with both member and owner permissions.
Any help appreciated.
Jan 24 2020 07:51 AM - edited Jan 27 2020 06:53 AM
Hello, TheJakes,
We are still experiencing this issue. I have raised a ticket with Microsoft Support, but have yet to find a solution. I am in the process of having the affected user try different document libraries and different permission settings in SharePoint to see if anything changes. I will update this post if I find a resolution.
Jan 24 2020 09:05 AM
Same issue here. Guess it could be global?
Jan 24 2020 12:53 PM
@mgudites1@lrc5333 I, too, am having this issue. We were able to create forms from SharePoint a week ago just fine, but now it doesn't seem like it's working on any of our sites and we get the same error: "You don't have permission to add a Form to this shared workbook. Create your own Excel workbook and try again." However, I can create a Form from SharePoint in the default document library (the document library that exists when the site is created, and can't be deleted by default). Is this the case for you too?
Jan 24 2020 01:01 PM
@gtew234 Good find! I just confirmed that the default document library causes no issues. However, I just created a new document library in a site I own and was able to replicate the problem. I wonder if something is breaking folder inheritance.
Jan 24 2020 01:09 PM
@lrc5333 Hmm, this may well be a global level issue. Maybe they're working on the Forms file upload functionality to expand it to external form respondents as well, and they broke something? But I'm just spitballing here.
Jan 24 2020 01:11 PM
I don't know if this helps but I was also able to go directly to forms.office.com and create a shared group form for the group in question. Doesn't solve the problem of wanting to have the document placed within the doc library but, for now it's a workaround here. I just put URL shortcuts into the doc library so the team could easily access the form and the 'results' page.
Jan 28 2020 12:37 AM
Hi, any feedback you have received on this? I hope a ticket was already submitted for this.
Jan 28 2020 05:13 AM
@GriefbladeNothing concrete yet. I have shared this thread with Microsoft.
Jan 29 2020 01:33 AM
Jan 29 2020 09:05 AM
Solution@RespectandPeace @Griefblade @mgudites1 @gtew234 @TheJakes
Microsoft got back to me with a fix that resolved this issue for our tenant. In the Office 365 admin center, navigate to Settings >> Services & add-ins >> Microsoft Forms. Toggle On the "Share form result summary" option if it's off (we have every option in here enabled).
Jan 30 2020 12:53 AM
@lrc5333 It was already ticked for us, but the problem is now resolved, so i suspect something changed to untick, and MS have now rectified.
May 02 2020 08:43 PM - edited May 02 2020 08:44 PM
@lrc5333 It's May and I'm still seeing this problem.
All the options under the Office 365 Admin for Forms are checked.
May 04 2020 05:52 AM
@Luke Chung You're better off starting a new thread or reaching out to Microsoft. The issue has not returned for our tenant.
May 03 2021 02:31 PM
I think this bug is related to the O365 Group linked to the SharePoint Team Site @lrc5333
After some testing we found out that if you are not a member of the O365 Group Linked to the SharePoint site or if the O365 linked Group permissions were removed from the site this error shows up
I think this happens because MS forms tries to login to SharePoint using the Linked O365 Group and not the actual account,
So if the Group doesn't have access to the Library, then it will error out,
We still need to do some more testing to prove this theory, but so far, when we re-add the user to the o365 group or we give permission to the O365 group back to the library, it works again
Jan 29 2020 09:05 AM
Solution@RespectandPeace @Griefblade @mgudites1 @gtew234 @TheJakes
Microsoft got back to me with a fix that resolved this issue for our tenant. In the Office 365 admin center, navigate to Settings >> Services & add-ins >> Microsoft Forms. Toggle On the "Share form result summary" option if it's off (we have every option in here enabled).