How to Fix Broken Microsoft Forms to Excel and SharePoint Connections
Question details
The user wants to repair or prevent broken data connections between Microsoft Forms and Excel workbooks stored in SharePoint or OneDrive.

- 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.
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.
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.
Log in to Microsoft 365 and open the specific form that has stopped syncing with your Excel workbook.
Click on the 'Responses' tab located at the top of the form design page to view the collected data.
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.

Keep Group Form Workbooks in Default SharePoint Libraries
Prevent future connection breaks by maintaining group form workbooks in their original Shared Library locations.
Manage Personal Form Copies in OneDrive
When you duplicate a non-group form, keep the resulting response workbook in your personal OneDrive to maintain the link.
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. Download the Software: Visit the official WPS Office website and download the free version for your PC or Mac.
- 2. Install WPS Office: Run the lightweight installer and follow the on-screen prompts to set up the software in minutes.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets to easily open, edit, and save your existing .xlsx files with complete formatting preservation.

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.




