SharePoint Document Issues

Fix Microsoft Forms Responses Not Syncing to Excel After Moving to SharePoint

Amos Gikunda Sep 25, 2026 869 views

Question details

The user needs to restore the data connection between a Microsoft Form and an Excel spreadsheet after migrating the Form to a SharePoint group.

Fix Microsoft Forms Responses Not Syncing to Excel After Moving to SharePoint

Product: Microsoft Forms, Excel, SharePoint
Device & OS: not provided
Scenario: Moving an existing Microsoft Form from a personal OneDrive account to a SharePoint group to share form ownership and responses with a team.
Observed behavior: The Microsoft Form link continues to work for users, but the associated Excel responses file breaks, either opening a blank page or displaying an error stating the Form was moved or deleted.

Before you start

Verify that your Microsoft 365 account has permissions to use Power Automate, as creating a new automated flow is the most reliable method to restore this data connection.

Solution 1Recommended

Use Power Automate to Sync New Responses

Create a Power Automate flow to automatically capture new Microsoft Forms submissions and send them to a newly formatted Excel spreadsheet.

Since the default connection often permanently severs during migration, using Power Automate establishes a robust, customizable link between your Form and a new Excel workbook.

Create a new Excel destination file

Open a blank Excel workbook in your SharePoint site. Create headers that match your Microsoft Form questions, highlight them, and click 'Insert' > 'Table' to format the range as a Table.

Remove special characters from headers

Review your Excel Table headers and delete any special characters, such as forward slashes (/), asterisks (*), or brackets. Special characters in the column headers will cause the Power Automate flow to fail.

Set up the flow trigger

Log into Power Automate and select 'Create' > 'Automated cloud flow'. Choose the trigger 'When a new response is submitted' and select your moved Microsoft Form from the dropdown list.

Map the data to Excel

Add a new action called 'Add a row into a table' for Excel Online (Business). Select your SharePoint site, the new Excel file, and the Table you created. Map each dynamic content field from the Form to the corresponding Excel column.

Save and test

Save the flow and submit a test response to your Microsoft Form to ensure the data successfully appears in your new Excel spreadsheet.

Use Power Automate to Sync New Responses

Automated Sync Restored: Once activated, the flow will run in the background automatically, securely adding every new Form submission directly into your designated SharePoint Excel file.

Solution 2

Troubleshoot Browser and Network Cache

Rule out browser caching or network connectivity issues that might prevent the default Excel results page from loading correctly.

Solution 3

Contact Your Microsoft 365 Administrator

Escalate the broken SharePoint link issue to your IT administrator if basic workarounds fail.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Management with WPS Office

While SharePoint and Power Automate integration errors require specific Microsoft 365 fixes, you can rely on WPS Office for all your everyday document and spreadsheet needs. WPS Office provides a lightweight, highly compatible alternative that handles complex spreadsheets flawlessly without cloud synchronization headaches.

Fully compatible with Microsoft Excel (.xlsx) formats, tables, and complex formulas.Free, lightweight design that consumes minimal system resources.Clean, familiar user interface ensuring a seamless migration with zero learning curve.Robust offline capabilities so your productivity isn't dependent on cloud sync connections.

microsoft office alternative - wps office

Frequently Asked Questions

Why does moving a Form to SharePoint break the Excel link?

Moving a Microsoft Form changes its underlying file directory from your personal OneDrive to a shared SharePoint site. This shift in directory paths frequently severs the background connection to the original Excel results file, causing it to fail when opened.

Can I reconnect the existing Excel file instead of making a new one?

Usually, once the built-in 'Open in Excel' live connection is broken during a migration, it cannot be easily re-linked. Using Power Automate to direct new submissions to a fresh Excel file is the Microsoft-recommended method to restore live syncing.

Why is my Power Automate flow failing to add rows to Excel?

The most common reason for a failed row insertion in Power Automate is the presence of special characters (such as slashes, brackets, or asterisks) in your Excel table's column headers. Ensure all headers use simple plain text.

Is there a manual way to get my Form responses if the sync is broken?

Yes. If the live link to Excel is broken, Microsoft Forms usually defaults to offering a 'Download a copy' option in the Responses tab. You can use this to manually download the current responses as an offline Excel file at any time.

Document & File Issues