Permission & Access Issues

How to Fix Excel Form Creation Error in Microsoft 365 Group or SharePoint

Guest Writer Sep 25, 2026 870 views

Question details

The user encounters a permission error when attempting to add a form to an Excel workbook accessed via a Microsoft 365 group, despite the feature working when opening Excel directly.

How to Fix Excel Form Creation Error in Microsoft 365 Group or SharePoint

Product: Microsoft Excel, SharePoint, Microsoft 365
Device & OS: not provided
Scenario: Adding a form to an Excel workbook hosted on a Microsoft 365 group team site or a standalone SharePoint communication site.
Observed behavior: An error appears preventing the creation of the Excel form when accessed through the Microsoft 365 group, indicating a discrepancy in site or group permissions.

Before you start

Verify whether your SharePoint site is a team site connected to a Microsoft 365 group or a standalone communication site, as permission requirements for creating forms differ significantly between the two.

Solution 1Recommended

Request Membership in the Microsoft 365 Group

If your workbook is on a team site connected to a Microsoft 365 group, you must have member or owner permissions to create an Excel form.

Microsoft 365 groups enforce strict access controls. Even if you can view the workbook, you cannot create or manage associated forms unless you are officially a member or owner of the group.

Identify the group owner

Open the SharePoint Team site or Microsoft 365 Group and click on the 'Members' count in the upper right corner to see the list of group owners.

Request member access

Contact the group owner and ask them to add your Microsoft account as a 'Member' to the group.

Refresh and create the form

Once your membership is confirmed, refresh the Excel workbook in your browser and try inserting the form again.

Request Membership in the Microsoft 365 Group

Alternative Workaround: If you only need the form created quickly and cannot get membership, ask an existing group member to create the Excel form on your behalf.

Solution 2

Verify Permissions on Standalone SharePoint Sites

For SharePoint communication sites that are not connected to a Microsoft 365 group, standard site and workbook permissions govern your ability to create forms.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet and Form Collaboration

Avoid complex SharePoint permission structures. WPS Office provides an all-in-one lightweight solution for creating spreadsheets, collecting data with WPS Form, and collaborating seamlessly with your team.

1. Download and Install WPS Office: Get the free WPS Office suite for a lightweight alternative to Microsoft Office.
2. Open Your Workbooks: Open and edit your existing .xlsx files with complete format compatibility.
3. Create and Share Forms: Use WPS Form to instantly collect data and share links with your team without navigating complex site permissions.

Free, lightweight, and easy to use across all devicesFully compatible with Microsoft Excel (.xlsx) formatsBuilt-in WPS Form for easy data collection and sharingSimplified cloud sharing without complex group permissions

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel form work locally but not in the Microsoft 365 group?

When you open an Excel workbook locally, it relies on your personal device permissions. However, when the file is hosted in a Microsoft 365 group, cloud permissions take over, requiring you to be an explicit Member or Owner to authorize the creation of connected forms.

Do I need a Microsoft 365 group to create an Excel form in SharePoint?

No. If you are using a standalone SharePoint communication site (which has no associated Microsoft 365 group), you only need sufficient site and workbook edit permissions to insert a form.

How do I find out who the Microsoft 365 group owner is?

You can find the group owner by opening the SharePoint site associated with the group and clicking the 'Members' link in the top right corner. Alternatively, you can view the group details in Outlook under the Groups section.

Document & File Issues