Others

Fix Microsoft Forms Excel Responses Not Syncing Until File Opens

Algirdas Jasaitis Oct 1, 2026 868 views

Question details

Users are experiencing an issue where Microsoft Forms data does not update in the linked SharePoint Excel workbook or downstream Power BI reports unless the Excel file is manually opened.

Fix Microsoft Forms Excel Responses Not Syncing Until File Opens

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Automating data collection from Microsoft Forms to an Excel workbook hosted on SharePoint to serve as a live data source for Power BI reporting.
Observed behavior: Power BI stops receiving updates because the Form responses fail to synchronize to the Excel workbook in the background, requiring a manual file open to trigger the sync.

Before you start

Ensure you have the appropriate permissions to edit the Microsoft Form, access the SharePoint Excel workbook, and create Power Automate flows within your Microsoft 365 environment.

Solution 1Recommended

Use Power Automate to Transfer Responses to Excel

Create a Power Automate flow to bypass the background sync limitation by directly inserting new form responses into your Excel dataset.

Microsoft recently updated how Forms syncs with Excel, which can sometimes require the file to be active. Using Power Automate provides a stable, automated data pipeline that operates independently of the Excel file's open state.

Create a new Power Automate flow

Go to Power Automate and create an 'Automated cloud flow'. Choose 'When a new response is submitted' (Microsoft Forms) as the trigger.

Get response details

Add a new step called 'Get response details' and select your Form ID and Response ID to pull the submitted data.

Add a row into a table

Add an 'Excel Online (Business)' action step called 'Add a row into a table'. Select your SharePoint site, Document Library, Excel file, and the specific Table.

Map the form fields

Map the dynamic content from your Form to the corresponding Excel table columns, then save and test the flow.

Use Power Automate to Transfer Responses to Excel

Test before deploying: Always test your new workflow with sample responses before removing any old connections to ensure Power BI receives the data correctly without duplicate entries.

Solution 2

Re-establish the Form to Excel Connection

Sometimes the live sync connection gets stuck, and recreating the linked workbook can restore background synchronization.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While complex enterprise workflows like Forms-to-Power BI require Microsoft's automated ecosystem, for everyday spreadsheet analysis, document editing, and presentations, WPS Office offers a free, lightweight, and highly compatible alternative. It provides a familiar user interface, making your daily data management effortless.

1. Download the software: Visit the official WPS website and download the free installation package.
2. Install WPS Office: Run the installer and follow the simple on-screen instructions to set up the suite.
3. Open your files: Launch WPS Spreadsheets and directly open your existing Excel workbooks to continue your analysis.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats for seamless data transition.Built-in advanced data analysis tools, pivot tables, and chart features for local reporting alternatives to Power BI.Free to use with a lightweight installation package that runs smoothly on most devices.Familiar tabbed user interface minimizes the learning curve for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Microsoft Forms stop syncing to Excel automatically?

Microsoft periodically updates the synchronization mechanisms between Forms and SharePoint Excel files. In some scenarios, these backend changes require the Excel workbook to be opened manually to trigger a refresh of the linked data connections.

Do I need a premium license to use Power Automate for this fix?

For basic Form to Excel data transfers, the standard Power Automate connectors available in most Microsoft 365 business plans are sufficient and do not require an additional premium license.

Will syncing to a new Excel workbook delete my old Form responses?

No, all responses are securely stored within Microsoft Forms itself. When you sync to a new workbook, it pulls all historical responses into the newly created Excel file.

How does this Excel sync issue affect my Power BI dashboards?

Power BI relies on the SharePoint Excel file for its data source. If the Excel file doesn't receive background updates from Forms, Power BI will only reflect data up to the exact point the Excel file was last opened and synchronized.

Office Quick Solutions