SharePoint Document Issues

How to Fix Broken Microsoft Forms to Excel and SharePoint Connections

Aamir Naveed AkramAamir Naveed Akram Nov 4, 2026 872 views

Question details

The user wants to repair or prevent broken data connections between Microsoft Forms and Excel workbooks stored in SharePoint or OneDrive.

How to Fix Broken Microsoft Forms to Excel and SharePoint Connections
Product
Microsoft Excel, Microsoft Forms, SharePoint
Device & OS
not provided
Scenario
Moving or copying a Microsoft Forms response workbook from its original SharePoint or OneDrive location to a new library.
Observed behavior
The data connection between Microsoft Forms and the Excel workbook breaks, causing new form responses to stop syncing to the spreadsheet.
Before you start

Verify that your Excel workbook is not currently checked out by another user in SharePoint, as a checked-out status makes the file read-only and can temporarily interrupt data synchronization.

Solution 1Recommended

Create a New Excel Response Workbook

If the connection is already broken because the original file was moved, the most reliable fix is to generate a completely new response workbook in the default location.

When a form's response workbook is moved to a different SharePoint library or removed from OneDrive, Microsoft Forms loses the file path. Reverting the move does not always restore the link, so generating a new sync file is required.

1
Open Microsoft Forms

Log in to Microsoft 365 and open the specific form that has stopped syncing with your Excel workbook.

2
Navigate to the Responses Tab

Click on the 'Responses' tab located at the top of the form design page to view the collected data.

3
Sync to a New Workbook

Click the More options (...) menu next to the 'Open in Excel' button and select the option to sync all responses to a new workbook. Microsoft Forms will automatically generate a new connected Excel file in the correct default storage location.

Create a New Excel Response Workbook
Data Preserved: Creating a new response workbook will pull all historical form responses into the new file, ensuring no data is lost.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are frustrated by strict file location rules and complex SharePoint syncing errors, WPS Office offers a lightweight, highly compatible alternative. Enjoy powerful spreadsheet management without the rigid cloud restrictions of the Microsoft ecosystem.

  1. 1. Download the Software: Visit the official WPS Office website and download the free version for your PC or Mac.
  2. 2. Install WPS Office: Run the lightweight installer and follow the on-screen prompts to set up the software in minutes.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets to easily open, edit, and save your existing .xlsx files with complete formatting preservation.
100% compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight installation that runs smoothly on older devicesEasy local file management without mandatory cloud sync restrictionsFamiliar user interface for a seamless transition
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Microsoft Forms Excel workbook stop updating with new responses?

This typically occurs if the Excel response workbook was moved, renamed, or deleted from its original SharePoint or OneDrive location. Moving the file breaks the synchronization link that Microsoft Forms uses to send new data to the spreadsheet.

Can I move a group form's Excel file to another SharePoint document library?

No. Moving the response workbook to a different SharePoint library breaks the connection between the form and the Excel file. The workbook must remain in the default Shared Library where it was originally created by the group form.

What does checking out a file in SharePoint do to my Excel workbook?

Checking out a file in SharePoint makes it read-only to other users, ensuring data integrity while you make exclusive edits. You must check the file back in so that others can view the changes and so automated processes can interact with the file normally.

How do I fix a broken link if I already moved my OneDrive response file?

You generally cannot repair the broken link of a relocated file. Instead, log in to Microsoft Forms, navigate to the Responses tab for that specific form, and select the option to sync responses to a new workbook. This will generate a fresh, correctly linked file.