User Profile
lrc5333
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Error when attempting to add a Form to an Excel workbook
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? EDIT: This is reproducible 100% of the time when attempting the above steps from a new SharePoint document library. The existing (default) library does not seem to be affected.Solved16KViews0likes15CommentsRe: Error when attempting to add a Form to an Excel workbook
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).16KViews0likes1CommentRe: Error when attempting to add a Form to an Excel workbook
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.15KViews0likes0CommentsRe: Error when attempting to add a Form to an Excel workbook
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.15KViews0likes1Comment
Recent Blog Articles
No content to show