TL;DR
Microsoft: “Microsoft Forms will replace the older data sync to Excel with a new, more reliable solution on January 13, 2025. Users must manually migrate to the new solution, which will be available worldwide starting late September 2024. Notifications and support for migration will be provided. Rollout completion is expected by mid-January 2025”.
Details
The content below (the details section on this page) is copied word for word from the Microsoft message centre:
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
Users who rely on the older version to sync data from Forms to Excel will need to manually update the data sync to the new solution before January 13, 2025 (previously October 20, 2024). After this date, existing Excel files with the older data sync will be retained but will no longer receive automatic data updates from Forms.
The older version of the data sync exists in two types of Forms:
- Forms created from Microsoft OneDrive and Excel for the web
- Group forms created with SharePoint Online, Microsoft Teams, and Microsoft 365 Groups.
For these two types of Forms, we will provide this support to migrate to the new solution:
- Users who own Forms with the older version of the data sync will get notifications through email, Forms, and Excel for the web.
- In Forms, users will be able to recreate the data sync with the new solution. A new worksheet will be created in the same workbook as the older data sync. The new worksheet will be connected to the latest data from Forms.
- After the older solution is retired, the user can still recreate a new data sync to the Excel workbook.
For workflows that connect to Excel data from Forms responses (such as Power Automate workflows), users will need to update the workflow to the Forms connector for new response updates. Learn more: Create an automated workflow for Microsoft Forms – Microsoft Support
Note: The new data sync can only be triggered in Excel for the web. If users want to receive new Forms response data in the Excel desktop app, open the file in Excel for the web, and then wait for the desktop app file to sync from the web file. (Support for other versions of Excel is in progress.)
The new data sync solution will be on by default and available to all Forms and Excel for the web customers.
Notification in Forms to update workbook to continue syncing with Forms:
Notification in Excel for the web to update the data sync to new solution:
Excel workbook is successfully updated to new solution:
Availability
Support for migrating the older data sync to the new solution is due late September 2024 to early October 2024.
The older version of live data sync will be replaced by the newer solution on 13th January 2025.
Source, related links, and references
MC855685.
365 Roadmap ID 410988.
Image(s): Microsoft.
Related: Microsoft Forms now supports live data sync to Excel with more functionality – Super Simple 365.
Related: Introducing Forms data sync to Excel – Microsoft Community Hub.
Ask a question
Discuss and share this update on X/Twitter, Threads or LinkedIn.
Suggested action
Please share this page with your colleagues who use Forms so they can prepare for this update.
Page originally published
19 September 2024 and kept up to date.
See what else is late, new, and coming soon across M365 and Teams this month with the latest roundup.
🎦 Want to find innovative ways to exploit M365 within small teams across your organisation using the M365 apps you are already paying for, led by just one person? Re-watch my webinar with The Inform Team: ‘Efficiency at its finest: Making sure innovation is at the heart of your organisation’. Watch on YouTube (30 mins).
