'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why Forms for Excel is Missing from the Teams or SharePoint New Menu
Question details
Users are unable to find the Forms for Excel option in the New menu of Microsoft Teams or SharePoint document libraries, even though it appears as an option in the Edit New Menu settings.
- Product
- Microsoft Teams and SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to create a new Form for Excel directly from a Teams channel or SharePoint document library.
- Observed behavior
- The Forms for Excel option is completely absent from the actual New dropdown menu, preventing users from creating forms, despite being visibly selected in the configuration settings.
Ensure that Microsoft Forms is enabled for your organization and that you have a stable internet connection before troubleshooting tenant or cache issues.
Verify Tenant Type and Microsoft 365 Licensing
Check if your organization's Microsoft 365 tenant restricts Forms for Excel, particularly in Government or restricted environments.
The availability of Forms for Excel heavily depends on your Microsoft 365 service plan and rollout status. Some government-cloud environments (like GCC, GCC High, or DoD) have strict limitations that prevent Forms for Excel from functioning or appearing in the SharePoint/Teams integration.
Reach out to your organization's IT department or Microsoft 365 Tenant Administrator.
Ask the administrator to confirm in the Microsoft 365 Admin Center that Microsoft Forms is turned on for your specific user account.
If you are in a government tenant, have the admin review the latest Microsoft Forms licensing documentation to see if Forms for Excel has been rolled out to your specific environment.
Clear Browser Cache and Test Alternative Access
Resolve potential browser caching issues that might cause the New menu configuration to display incorrectly.
Submit Feedback for UI Sync Issues
Report the discrepancy to Microsoft if the feature is listed in configuration but missing in reality.
Looking for a simpler way to manage spreadsheets?
While Microsoft 365 features like Forms for Excel can be delayed by complex tenant configurations or government cloud restrictions, WPS Office provides a hassle-free, lightweight alternative for all your spreadsheet tasks.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the software: Run the installer and follow the on-screen prompts to set up WPS Office on your device.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and instantly open your existing .xlsx files with complete format retention.
Frequently Asked Questions
Does using a government tenant prevent Forms for Excel from being used?
Yes, depending on the specific government cloud environment (such as GCC, GCC High, or DoD), Forms for Excel may not be fully rolled out or supported yet. Check with your IT administrator for your tenant's specific capabilities.
Why does Forms for Excel appear in the Edit New Menu settings but not in the actual menu?
This discrepancy often occurs due to product sync issues or caching. The SharePoint interface may load the generic list of possible options in the Edit menu, but the actual New menu dynamically hides the option if your specific tenant or user license lacks the required permissions.
Are there other ways to create a Form linked to Excel?
Yes, you can often bypass the SharePoint/Teams menu by going directly to the Microsoft Forms web portal, creating your form there, and selecting the option to sync or export the responses to an Excel workbook.
