Others

How to Fix Forms for Excel Opening Excel Directly Instead of Creating a Form

Aamir Naveed Akram Oct 1, 2026 868 views

Question details

The user is attempting to create a Form for Excel from OneDrive, but the action opens an Excel workbook directly instead of launching the Microsoft Forms creation page.

How to Fix Forms for Excel Opening Excel Directly Instead of Creating a Form

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a new Form for Excel via Microsoft OneDrive.
Observed behavior: Selecting 'Create' opens Excel directly, and the expected test form does not appear on the Microsoft Forms home page.

Before you start

Ensure you are logged into your Microsoft 365 account with an active internet connection so that your OneDrive and Microsoft Forms can synchronize properly.

Solution 1Recommended

Use the Insert Menu to Initialize the Form within Excel

Due to an update in the Forms for Excel experience, the initial form setup must now be completed from the Insert tab inside the generated Excel workbook.

This behavior is part of a planned update to the Forms for Excel workflow in Office 365. When you initiate a new form from OneDrive, the system intentionally creates the destination workbook first to ensure that your future form responses have a dedicated location to sync.

Open the generated workbook

Wait for the Excel workbook that was just created from OneDrive to fully load in your web browser.

Navigate to the Insert tab

On the top ribbon menu of Excel, click on the 'Insert' tab to reveal the available tools and add-ins.

Select New Form

Locate the 'Forms' option in the toolbar. Click on it and select 'New Form' from the drop-down menu.

Create a test question

The Microsoft Forms interface will now launch. Add a simple test question to officially initialize and save the form.

Verify data synchronization

Submit a test response through the form link, then check your Excel workbook to verify that the data successfully populates into the spreadsheet.

Use the Insert Menu to Initialize the Form within Excel

Form Sync Established: Once initialized through the Excel file, the form will become visible on your main Microsoft Forms home page and will remain synced to this specific workbook.

WPS Forms and Spreadsheets Integration

Easily Collect Data with WPS Forms

WPS Office offers a built-in, user-friendly Forms tool. You can quickly create a form and have all responses automatically collected into a WPS Spreadsheet without dealing with confusing OneDrive routing.

1. Open WPS Spreadsheet: Launch WPS Office on your device and open a new or existing spreadsheet.
2. Access WPS Form: Navigate to the 'Tools' tab and select the 'WPS Form' icon to begin creating your survey.
3. Design your form: Add your required questions, customize the visual layout, and finalize the form settings.
4. Collect and view responses: Share the generated form link with your respondents and watch the data automatically organize itself into your WPS Spreadsheet.

Seamless real-time integration between WPS Forms and WPS Spreadsheets.Fully compatible with Microsoft Excel (.xlsx) formats and standard workflows.Free, lightweight, and intuitive data collection alternative.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my new form appear on the Microsoft Forms home page immediately?

When creating a form via Forms for Excel from OneDrive, the form is tied directly to the workbook. It might not appear on the main Forms dashboard until you manually insert a new form from within the Excel workbook and add at least one question.

How do I know if my form responses are successfully syncing to Excel?

You can verify synchronization by submitting a quick test response to your newly created form. Open the linked Excel workbook; the data should automatically appear in a new row within a few moments.

Can I unlink the form from the Excel workbook later if I change my mind?

Forms created directly through the 'Forms for Excel' feature are permanently linked to that specific workbook to guarantee data routing. If you no longer need the connection, you can delete the form, but you cannot redirect it to a different workbook.

Office Quick Solutions