Aug 04 2020 06:52 AM
Aug 04 2020 06:52 AM
I have tried to add the 'Forms for Excel' feature in the +New option of a Modern Document library but it never works - please can you advise what I am doing wrong? It currently looks like this:
When I click on 'Edit New Menu', I have the following selected. After pressing Save, nothing changes.
All suggestions would be very welcome please?
Aug 05 2020 12:47 AM
@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.
Aug 05 2020 03:39 AM
Hi @Magnus Goksøyr, there isn't a file connected with this link - it is just the standard option that Microsoft provide.
Aug 06 2020 05:27 AM
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.
Aug 06 2020 06:44 AM
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?
Aug 06 2020 09:22 AM
Thanks for the swift and detailed comeback. As a comparative experience I've tried the following steps on my development tenancy
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: -
I'm out of ideas for the moment sadly but will come back with anything else should inspiration strike.
Aug 07 2020 12:10 AM
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?
Aug 07 2020 12:38 AM
@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-h...
Aug 07 2020 02:18 AM
Thanks for the suggestion @Magnus Goksøyr
I have worked through those options but sadly they didn't have any impact, however, everything is worth a try.