Forum Discussion
Unable to add Forms for Excel to +New in Document library
yes, I had same issue, & found Solution for it.
"Forms for Excel" feature only support SharePoint site which has been connected with a M365 group.
to fix it, Connect site with M365 Group.
after connecting with M365 Group, this issue fixed and showing "forms for Excel"
Thanks for the swift and detailed comeback. As a comparative experience I've tried the following steps on my development tenancy
- Navigated to a newly created team site and created a document library
- Used the New --> Edit New Menu as you've mentioned and I can replicate the error. Interestingly enough this also appears to be the case for Vision Drawing
So I can confirm your findings. Checking the comments on that blog post, I'm seeing a Kelly Jones post that mentions this functionality only works in modern sites, which are as you've identified. So, I'll go test that in a brand new Modern SharePoint site. Got the same result.
Some left field things I've tried: -
- Activating Content Type management on the libraries then editing the menus. No impact
- Creating a brand new survey in forms. No impact
I'm out of ideas for the moment sadly but will come back with anything else should inspiration strike.
Thanks Steven Andrews for your quick response and all your tests - it is useful to know that I am not the only one with this issue. I knew that the 'Visio Drawing' option didn't work either, but we don't use Visio - so I wasn't bothered.
I did a quick search and found this site: https://www.howtoexcel.org/general/microsoft-forms/which shows that someone has managed it. I tried creating a new Subsite and it failed again.
If something does strike Steven Andrews , or someone else has an idea - I would welcome any contributions please?
Steve Rowland a wild guess here but can it be related to this? https://docs.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/excel-survey-does-not-have-full-functionality-when-click-new
Thanks for the suggestion MagnusGoksoyrOLDProfile
I have worked through those options but sadly they didn't have any impact, however, everything is worth a try.
Steve Rowland did you ever get a solution? I am having exactly the same issue
