Forms for Excel not available in Sharepoint

There's absolutely no reason this simple functionality shouldn't be available in any kind of site - there's no essential difference other than cosmetics/default permissions between team, communications and One Drive sites. They are ALL Sharepoint. So I'm not buying any of the excuses above - this is an oversight or a bug and it's shocking it hasn't been addressed yet.

This is very frustrating. I spend alot of time educating my users to store corporate content in SharePoint and NOT OneDrive so that it can live independently of their participation in a department, project, group or company. It feels like Microsoft is undercutting that message with this. The fact that the option exists in the "New" menu but doesn't work is very confusing. If you show something as "Active" then it should be active or don't show it.

As much as I love Teams, SharePoint still has an important place in our content management approach. Not every artifact belongs in a Team and creating new Teams just to store this one artifact seems ridiculous - worse even than storing it in OneDrive. I know Microsoft wants us to move to modern group-enabled sites, but we have 1,000's of sites in our tenant. Those sites are not going away and many of them are subsites that cannot be groupified. Also, group-enabled sites do not allow for the same level of permission control as traditional SharePoint permissions.

Any idea when this will be fixed?

Dear Canon Turner

Thank you for your quick response and we also appreciate you spent your precious time doing the tests and providing the detailed screenshots to us.

Per your update, for your first reply, we did a test on our end and yes, we can reproduce the same result as yours if the connection broken after moving the excel to SharePoint document library.

So, we did further search and tests, then we found that Forms for Excel is still can be available in Team site, but in Communicate site, this feature can't support for now.

In Communicate site:

In team site, we can create Forms for Excel, and it was saved in SharePoint document library:

So please kindly have a test in Team site on your end and check if you can add Forms to Excel files and then saved in SharePoint.

If you need any further assistance, please feel free to post back.

Really appreciate your patience and understanding again.

Sincerely,

Stacey | Microsoft Community Moderator

Have there been any updates to this? Hosting the response form on SharePoint is necessary.

I am looking to have our form be public to the company, but the response spreadsheet is only accessible to a small team. The responses need to be restricted from view and edit permissions to the rest of the company. Is this possible when hosted on the public Teams Group? When I try to manage access, the options are unavailable.

In your case, I would use a SharePoint list. Forms is NOT the solution you want for on-going data collection. I do this so frequently, I can build it in my sleep. works like a charm AND is WAY more stable than Forms.

1. You need to find a site that is open to everyone in your company.
2. Then post the list on the site but do NOT put any navigation links to the site out in the open.
3. Next, do whatever you need to modify the native SharePoint form - reorder the fields, add your conditional show/hide expressions, etc.
4. Create a page about your data collection and list - cuz we NEVER present conTENT without a conTEXT.
5. Open a new item in your list and COPY LINK.
6. Put that link in notepad and edit the SOURCE so it goes back to the same page or a Thank You page. By default when the user saves/cancels the item, SharePoint will send them back to the full list. This will prevent that and send them wherever you want them to go. This is easy. I'm a language/literature major by training and even I can do this much.
7. Put the edited link on your page.

Now when people click the link, they will get the form to open full screen and when they save/cancel, they will go back to whatever page you specify.

This is a MUCH more stable option than forms for collecting data. And you have many, many more options for field types like choice, lookup, etc. You can even have attachments. If you want to get really fancy, you could even throw a Power App in front of it.

Dear Canon Turner

Good day! Thank you for posting in Microsoft Community. We are happy to help you.

Based on your description, we noticed you have two concerns about your query, we'll focus on them one by one.

1. Forms with an Excel Online is available in OneDrive for Business not in SharePoint.

According to the official article mentioned: if you're created your Form in OneDrive or in Excel for web then select Open in Excel,  your Excel workbook is automatically stored in OneDrive for work or school and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

If you worry about the Form you'll can't access after the owner leaving, you can move the files to a SharePoint document library via Move to or Copy to function and select the site library which you want to move.

2. You mentioned that 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*.* Per our test, we can click Insert>Forms>New Form in Excel online, then it will show the +Add New option, we can click it to create the Form for this Workbook.

What do you mean that when click new, not none of the options? Can you show us the screenshot of this to us?

If this is not your scenario or any unclear, you can post back in your free time. We’re looking forward to your reply and will continue to help you all the time!

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Stacey | Microsoft Community Moderator