OneDrive File Issues

How to Reconnect a Microsoft Form After Moving Its Excel Workbook

Rana Garcia Oct 13, 2026 869 views

Question details

The user needs to restore the synchronization between a Microsoft Form and its Excel response sheet after moving or modifying the file.

How to Reconnect a Microsoft Form After Moving Its Excel Response Workbook

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: The user moved, renamed, or reorganized the Excel workbook connected to their Microsoft Form responses within OneDrive.
Observed behavior: The synchronization breaks, causing an 'Excel workbook is missing' error when trying to view form responses.

Before you start

Ensure you are signed into the Microsoft 365 account of the user who originally created the form, as only the owner can manage the workbook sync settings.

Solution 1Recommended

Sync Form Responses to a New Excel Workbook

Use this method to establish a fresh connection and recover your form data by syncing all existing responses to a brand new Excel workbook.

Because modifying or moving the original response workbook disrupts the file path, Microsoft Forms cannot automatically locate it. The most reliable fix is to force the form to generate and sync to a new workbook in your OneDrive.

Sign in to Microsoft 365

Log into your Microsoft 365 account using the credentials of the user who created the affected Microsoft Form.

Launch Microsoft Forms

Open OneDrive, click the app launcher (waffle icon) in the top left corner, and select Forms. Then, navigate to 'My Forms'.

Open the Affected Form

Locate the form that is experiencing the sync issue and click to open it. Switch to the 'Responses' tab at the top of the screen.

Sync to a New Workbook

Click the three-dot menu icon next to the 'Open in Excel' button. Select 'Sync all responses to a new workbook' from the dropdown menu to re-establish the connection.

Sync Form Responses to a New Excel Workbook

Prevent Future Disconnections: To avoid breaking the synchronization again, refrain from moving, renaming, or restructuring the new response workbook inside your OneDrive.

Free Microsoft Office alternative

Handle Your Exported Spreadsheets Easily with WPS Office

While Microsoft Forms handles your data collection, you can rely on WPS Office as a lightweight, free alternative to Microsoft 365 for analyzing and formatting your exported Excel responses. Enjoy a familiar interface and seamless compatibility without the subscription fees.

1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
2. Open Your Form Responses: Launch WPS Spreadsheet and open the .xlsx response file downloaded from Microsoft Forms.
3. Analyze the Data: Use built-in charts, pivot tables, and formulas in WPS to effortlessly analyze your form responses.

100% compatible with Microsoft Excel (.xlsx) formatsLightweight design ensures fast loading of large response datasetsCompletely free alternative to Microsoft OfficeFamiliar user interface for seamless migration and zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why did moving my Excel workbook break the Microsoft Form?

Microsoft Forms relies on a specific file path in OneDrive or SharePoint to sync responses. When you move or rename the workbook, the file path changes, causing the form to lose its connection and display the 'Excel workbook is missing' error.

Will I lose my existing form responses when syncing to a new workbook?

No, you will not lose your data. Microsoft Forms stores all responses internally. When you select 'Sync all responses to a new workbook', it pushes all historical and future responses into the newly created Excel file.

Can I reconnect my Microsoft Form to the exact same moved Excel file?

Currently, Microsoft Forms does not support manually relinking to an existing workbook once the connection is broken. The only supported workaround is to let Forms create and sync to a new workbook.

Document & File Issues