How to store a Form for Excel in my company's primary SharePoint site (O365)?

%3CLINGO-SUB%20id%3D%22lingo-sub-357486%22%20slang%3D%22en-US%22%3EHow%20to%20store%20a%20Form%20for%20Excel%20in%20my%20company's%20primary%20SharePoint%20site%20(O365)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms-Blog%2FForms-for-Excel-new-experience-for-Excel-survey-in-Office-365%2Fba-p%2F109195%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms-Blog%2FForms-for-Excel-new-experience-for-Excel-survey-in-Office-365%2Fba-p%2F109195%3C%2FA%3E%20shows%20a%20few%20way%20to%20create%20Forms%20and%20have%20the%20responses%20sync'ed%20to%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20company%20is%20using%20O365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWhen%20I'm%20in%20a%20O365%20Group's%20SharePoint%20site%2C%20I%20can%20see%20the%20%3CSTRONG%3ENew%20%26gt%3B%20Form%20for%20Excel%3C%2FSTRONG%3E%20menu%20item.%3C%2FLI%3E%3CLI%3EWhen%20I%20use%20Excel%20Online%20to%20edit%20an%20Excel%20spreadsheet%20that's%20stored%20in%20a%20O365%20Group's%20shared%20documents%20folder%2C%20I%20can%20see%20the%20%3CSTRONG%3EInsert%20%26gt%3B%20Forms%20%26gt%3B%20New%20Form%3C%2FSTRONG%3E%20menu%20item.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20these%20menu%20items%20aren't%20available%20for%20my%20company's%20main%20SharePoint%20site%20(%3CA%20href%3D%22https%3A%2F%2Fmy-company.sharepoint.com%2FShared%2520Documents%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmy-company.sharepoint.com%2FShared%20Documents%2F%3C%2FA%3E).%20How%20can%20I%20enable%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357486%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/Forms-for-Excel-new-experience-for-Excel... shows a few way to create Forms and have the responses sync'ed to Excel.

 

My company is using O365.

 

  • When I'm in a O365 Group's SharePoint site, I can see the New > Form for Excel menu item.
  • When I use Excel Online to edit an Excel spreadsheet that's stored in a O365 Group's shared documents folder, I can see the Insert > Forms > New Form menu item.

 

However, these menu items aren't available for my company's main SharePoint site (https://my-company.sharepoint.com/Shared Documents/). How can I enable them?

 

Thanks!

0 Replies