Data Import & Export

How to Resync Microsoft Forms Responses After Moving to SharePoint

Bushra ParveenBushra Parveen Oct 28, 2026 872 views

Question details

The user needs to resync Microsoft Forms responses to an Excel workbook after moving the form from OneDrive to a SharePoint site.

How to Resync Microsoft Forms Responses After Moving to SharePoint
Product
Microsoft Forms, Microsoft Excel
Device & OS
not provided
Scenario
Moving an active Microsoft Form to a Teams SharePoint site while relying on live data sync and Power Query.
Observed behavior
The original Excel response workbook stops receiving new form submissions, and existing Power Query connections break.
Before you start

Ensure you have the necessary edit permissions for both the Microsoft Form and the destination SharePoint site before generating a new sync workbook.

Solution 1Recommended

Sync All Responses to a New Excel Workbook

Because Microsoft Forms cannot easily be relinked to the original moved workbook, the official and most reliable fix is to force the form to generate a brand new response workbook.

When a form is moved to a group or SharePoint, the background data connection linking the form to the original Excel file is severed. Creating a new workbook will pull all historical responses and re-establish the live sync for future submissions.

1
Open the form in Microsoft Forms

Log into Microsoft Forms and open the specific form that you recently moved to SharePoint.

2
Navigate to Responses

Click on the 'Responses' tab located at the top of the form design page.

3
Access the Excel options menu

Locate the 'Open in Excel' button, click the three-dot menu (More options) directly next to it.

4
Generate a new workbook

Select 'Sync all responses to a new workbook' from the dropdown menu. This will create a fresh Excel file in the SharePoint document library with an active live sync.

5
Reconfigure Power Query

Open your reporting file and update your Power Query data source settings to point to the newly generated Excel workbook URL on SharePoint.

Power Query Updates Required: Since you are pointing to a completely new file, any existing Power Query scripts or Power BI dashboards relying on the old file must have their data source paths updated.
Free Microsoft Office alternative

Analyze Exported Form Data for Free with WPS Office

While Microsoft Forms requires Excel for live background syncing, you can easily open, analyze, and manage the downloaded response workbooks using WPS Office. It provides a lightweight, highly compatible environment for all your spreadsheet data analysis needs without the costly subscription.

  1. 1. Download your responses: Download the newly generated response workbook from your SharePoint site to your local drive.
  2. 2. Open in WPS Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open your downloaded .xlsx file.
  3. 3. Analyze your data: Use WPS Spreadsheet's built-in pivot tables and charts to analyze your Microsoft Forms data easily.
Fully compatible with Microsoft Excel (.xlsx) formatsLightweight and fast, ideal for handling large response datasetsFree built-in data analysis, pivot tables, and visualization toolsFamiliar user interface with zero learning curve for seamless migration
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel workbook stop receiving Forms responses?

When a form is moved from a personal OneDrive to a SharePoint site or Teams group, the internal connection to the original Excel file breaks. The form continues to collect data, but it can no longer push that data to the disconnected workbook.

Can I link the form back to my original Excel file?

No, Microsoft Forms generally does not support relinking to an existing or original workbook once the connection is broken. You must use the 'Sync all responses to a new workbook' option to restore live syncing.

What happens to my existing Power Query connections?

Your existing Power Query connections will fail because they are pointing to the old, disconnected workbook that is no longer receiving updates. You will need to change the Data Source Settings in Power Query to point to the new workbook generated in SharePoint.

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

No. When you select 'Sync all responses to a new workbook', Microsoft Forms pulls all historical responses stored in its backend along with any new submissions, so no data is lost.