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"
Steve Rowland which file format does the file have? If it is .xlsx i think You first have to save it as a *.xltx before adding it to the library.
Hi MagnusGoksoyrOLDProfile, there isn't a file connected with this link - it is just the standard option that Microsoft provide.
Looks like we need some trouble shooting. Have you tried creating a brand new library on the same site and seeing if this exact issue occurs there too?
And to double check if there's any issue with the particular library you're using, maybe try an alternative way to create a Forms linked Excel book as mentioned here.
Hi Steven Andrews, thanks for your suggestions. I have now tried in two different Site Collections and several different Document libraries and they all react the same way. One of these Site Collections is only a few months old. My colleague (who has greater access than myself as a mere Site Collection Administrator has seen the same issue in other places because this SharePoint online is shared across 40 schools.
In the link you sent it said that it works in a "Document library of modern SharePoint team sites (O365 group backed): Click + New". This made me wonder whether it is the lack of being part of an O365 group, so I tried the File area of a Teams file area - Forms for Excel appears perfectly. I don't know how I would get a standard SharePoint site to be O365 backed.
I have even tried adding a new Template but I don't know exactly what a Forms for Excel template would be like - any suggestions welcome please?
I look forward to any more ideas please?
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.
