Others

Fix Forms for Excel Creating a Workbook but Not a Form in Teams

Rana Garcia Oct 7, 2026 870 views

Question details

Users need to automatically generate both a workbook and a linked Microsoft Form using the Forms for Excel feature, but currently only the workbook is created.

Fix Forms for Excel Creating a Workbook but Not a Form

Product: Microsoft Excel, Microsoft Teams, SharePoint
Device & OS: not provided
Scenario: Creating a new Forms for Excel file within a Microsoft Teams channel or SharePoint library.
Observed behavior: The system successfully generates an Excel workbook but fails to create the corresponding Microsoft Form, leaving the form invisible in the Forms app.

Before you start

Ensure you have the necessary permissions to create files and forms within your Microsoft 365 environment, and check if your Teams client has been recently updated.

Solution 1Recommended

Manually Create and Link the Form in Teams

Use this workaround to manually generate and connect the Microsoft Form directly from within the newly created Excel workbook in Teams.

Since the automatic generation is currently experiencing service issues in Teams and SharePoint, manually inserting the form from the Excel ribbon is the most reliable immediate fix.

Open the Workbook

Navigate to your Microsoft Teams channel or SharePoint library and open the newly created Excel workbook.

Navigate to the Insert Tab

On the top ribbon inside the Excel interface, click on the 'Insert' tab.

Insert a New Form

Click on 'Forms' and then select 'New Form' from the dropdown menu to manually create and link the form to your workbook.

Manually Create and Link the Form in Teams

Workaround Successful: The manually created form will now properly sync its responses to your Excel workbook just as the automated feature would.

Solution 2

Create the File Using OneDrive for Web

Bypass the Teams and SharePoint service glitch by initiating the file creation directly through OneDrive for the web.

Solution 3

Submit a Service Request via Microsoft 365 Admin Center

Since this is a documented service issue rather than a feature retirement, administrators should report it directly to Microsoft.

Free Microsoft Office alternative

Try WPS Office for Reliable and Lightweight Spreadsheet Management

If you are experiencing disruptions with Microsoft 365 cloud services and feature integrations like Forms for Excel, consider WPS Office. It provides a stable, offline-capable, and powerful spreadsheet tool that won't get bogged down by cloud synchronization errors.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your preferred device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and easily open your existing .xlsx files directly from your local drive or cloud storage.
3. Utilize WPS Form: Navigate to the Tools tab to explore WPS Form for an easy, built-in alternative to data collection.

Seamlessly view, edit, and save Microsoft Excel (.xlsx) formats without compatibility issues.Create forms and collect data efficiently using WPS Form, fully integrated into the suite.Lightweight application that uses fewer system resources than standard Microsoft Office installations.Enjoy a familiar user interface that requires zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Is the Forms for Excel feature being retired?

No. According to Microsoft documentation, Forms for Excel is still a fully supported feature. The issue of it only creating a workbook is recognized as a service glitch, likely related to recent updates in the Teams client, rather than an intentional retirement.

Why isn't my Microsoft Form showing up when I create it in Teams?

Due to a current service issue within Microsoft Teams and SharePoint, the 'Forms for Excel' option is only generating the destination workbook and failing to trigger the creation of the form. You can bypass this by opening the workbook and using Insert > Forms > New Form.

Can I still link a Microsoft Form to an existing Excel workbook?

Yes. You can manually link a form to any compatible Excel workbook by opening the file, navigating to the 'Insert' tab on the ribbon, and selecting 'Forms' followed by 'New Form'. This establishes a direct connection for your response data.

Office Quick Solutions