How to Resync Microsoft Forms Responses After Moving to SharePoint
Question details
The user needs to resync Microsoft Forms responses to an Excel workbook after moving the form from OneDrive to a SharePoint site.

- 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.
Ensure you have the necessary edit permissions for both the Microsoft Form and the destination SharePoint site before generating a new sync workbook.
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.
Log into Microsoft Forms and open the specific form that you recently moved to SharePoint.
Click on the 'Responses' tab located at the top of the form design page.
Locate the 'Open in Excel' button, click the three-dot menu (More options) directly next to it.
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.
Open your reporting file and update your Power Query data source settings to point to the newly generated Excel workbook URL on SharePoint.
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. Download your responses: Download the newly generated response workbook from your SharePoint site to your local drive.
- 2. Open in WPS Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open your downloaded .xlsx file.
- 3. Analyze your data: Use WPS Spreadsheet's built-in pivot tables and charts to analyze your Microsoft Forms data easily.

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.




