Fix Microsoft Forms Responses Missing in Excel Workbook in Teams
Question details
Users are unable to see submitted Microsoft Forms responses in the linked Excel workbook within Microsoft Teams.

- Product
- Microsoft Forms / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on Microsoft Teams and syncing form submissions to a shared Excel workbook.
- Observed behavior
- Form responses appear successfully in Microsoft Forms but fail to populate, update, or synchronize in the connected Excel workbook.
Ensure you have the appropriate edit permissions for both the Microsoft Form and the linked Excel workbook within your Teams channel before modifying connection settings.
Sync All Responses to a New Excel Workbook
This is the most effective way to re-establish a broken connection and force all existing data to populate into a fresh, synchronized spreadsheet.
When the connection between Forms and Excel breaks, the easiest resolution is to generate a completely new workbook. This ensures all historical data and future responses map correctly without manual data entry.
Navigate to Microsoft Forms in your web browser and open the specific form that is experiencing the synchronization issue.
Click on the 'Responses' tab located at the top of the form interface to view your collected data.
Click the three-dot icon (More options) located on the right side of the Responses screen.
Select 'Sync all responses to a new workbook' from the dropdown menu and click 'OK' to confirm.
Have a user submit a test response, then click 'Open in Excel' from the Responses tab to verify that the new test data populates in the new spreadsheet.

Verify Response Limits and Active Connections
Forms might stop updating if they hit their maximum response limits or if the connection to the Excel file was manually broken.
Manage Your Spreadsheets and Exported Data Easily with WPS Office
If you frequently work with exported survey data and need a fast, reliable, and cost-effective way to analyze spreadsheets, consider WPS Office. It is a highly compatible, lightweight alternative to Microsoft Excel that handles large datasets seamlessly without synchronization hiccups.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Data: Export your Forms responses as an .xlsx file from your browser and open it instantly in WPS Spreadsheet.
- 3. Analyze Seamlessly: Use WPS Spreadsheet's built-in formulas, charts, and pivot tables to analyze your survey data efficiently.

Frequently Asked Questions
Why are my Microsoft Forms responses not showing up in my Excel workbook?
The active data connection between the form and the workbook might be broken, out of sync due to network issues, or the form may have reached its maximum response limit preventing new data from being recorded.
Can I manually push missing Forms responses to Excel?
Yes. In the Responses tab of your Microsoft Form, click the three-dot options menu and select 'Sync all responses to a new workbook'. This will manually force a fresh sync and retrieve all existing responses into a new Excel file.
Does moving the Excel file in Teams break the Forms connection?
Yes, moving or renaming the connected Excel workbook within your Microsoft Teams channels or SharePoint directories can break the active data link, which stops new form responses from populating.




