This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
We used to have the ability to add Forms to Excel files that were saved in Sharepoint. This is important because it allows the user to share the form results with their colleagues, but more importantly, if the form owner leaves the organization, it allows the form and the spreadsheet to live on in Sharepoint. We've recently discovered that Forms with an Excel Online back-end only seems to be available for OneDrive for Business, or alternatively as a standalone worksheet that can be downloaded locally, which is not ideal.
In the 'Edit New Menu' screen, we can see the 'Form for Excel' button but when we click 'New' it not one of the options.
It seems Microsoft may have disabled this functionality unceremoniously. Which begs the question, what are users to do to ensure that a Form + Spreadsheet remain functional if the owner of the Onedrive where the spreadsheet lives leaves the organization? If you move the spreadsheet, the connection between the form and the spreadsheet seems to be lost. Needing guidance on this issue, please advise.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thanks, Stacey. We were able to add an Excel Form within the Teams Page. It's not an ideal solution but it will work for now. Appreciate your replies and help.
-Canon
Dear Canon Turner
Thank you for your quick response and we're happy to hear that you can add an Excel Form within the Teams Page. Regarding this feature in Communicate site, we'll reported to the developer team and hope they can improve the product as soon as possible and give users a better experience.
Besides, if you think this is helpful, please kindly submit the feedback as below picture, this will help the other users on the community to see it more clearly.
Really appreciate your patience and understanding.
Sincerely,
Stacey | Microsoft Community Moderator
I have a G5 license and cannot seem to access the Forms for Excel from either Excel (Insert, Form), OneDrive (New, Forms for Excel) or a modern Team SharePoint site (New, Forms for Excel). Could this be a limitation of licensing in a government tenant?
This feature is only available with a Modern SharePoint site connected to a Microsoft 365 group. If you made a MS Teams site then the underlying SharePoint Online site for the Teams site will have it available in the library. If the SharePoint Online site has been connected to a group, then it will show up. If the site can't be connected to a Microsoft 365 group, the Forms for Excel won't show up.
An idea may be to create a HUB site and make the forms for excel library there. Then connect the various other SharePoint sites to the HUB sites. We have one for Learning & Development and a library for forms feedback surveys. Then there are lots of departmental training sites and initiative sites that are connected to the HUB site.
Just a thought about architecting a solution without rebuilding the thousands of existing sites.
Licensing = E3
I have created SharePoint Online sites from Teams and still do not get the Forms for Excel option. It sounds like you are confirming this is not available in a G5 license.
Thanks!