How to Recover Microsoft Forms Responses After a Link Changes
Question details
Recover missing or split Microsoft Forms responses resulting from a modified or resent form link.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- The user changes or resends a Microsoft Forms link, leading to confusion over where the submitted data is being stored.
- Observed behavior
- Responses are split into a second form, linked to a different Excel workbook, or fail to appear in the expected SharePoint file.
Ensure you have owner or co-author access to the original Microsoft Form and know who your organization's Microsoft 365 administrator is.
Access the Live Response Workbook in Excel
Use the built-in 'Open in Excel' feature from the original form to access the currently connected live response workbook.
When a form link is changed or resent, the active data connection might be pointing to a different workbook than you expect. Opening the form directly and triggering the Excel view will fetch the most up-to-date response file.
Navigate to Microsoft Forms in your web browser, log in, and locate the original form that was receiving responses (not the copied or newly linked version).
Click on the 'Responses' tab at the top of the form layout to view the current response summary.
Select the 'Open in Excel' button. This will either open the existing connected workbook in SharePoint/OneDrive or create a new live workbook containing the latest responses.
Check the downloaded or opened Excel spreadsheet to ensure the missing responses are present in the rows.
Contact Microsoft Support via Your M365 Administrator
If responses are entirely missing and not visible in the connected Excel file, escalate the issue to Microsoft Support for potential backend recovery.
Analyze Exported Form Data Free with WPS Office
Once you recover and export your Microsoft Forms responses, you need a powerful tool to analyze the spreadsheet data. WPS Office provides a lightweight, free alternative to Microsoft Office that easily handles complex Excel files.
- 1. Export Responses: Download your recovered Microsoft Forms responses as an Excel (.xlsx) file.
- 2. Open with WPS Spreadsheet: Right-click the downloaded file and select 'Open with WPS Office' to view your data.
- 3. Analyze and Edit: Use WPS Spreadsheet's built-in filtering, sorting, and charting tools to organize your survey results seamlessly.
Frequently Asked Questions
Why did my Microsoft Forms responses stop updating in Excel?
This usually happens if the connected Excel file was moved, renamed, or corrupted, which breaks the live synchronization. You can resync the data by opening the form online and clicking 'Open in Excel' to generate a new connected workbook.
Can I combine the split responses from two different Microsoft Forms?
Yes. If responses were split across two separate forms, you can export the responses from both forms into separate Excel files, open them in a spreadsheet application, and manually copy and paste the rows into a single master spreadsheet.
Does sharing a Microsoft Form as a template duplicate the responses?
No. Sharing a form as a template only copies the form's structure and questions. It does not carry over the existing responses, and any new form generated from that template will start with zero responses.
