This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We used to have an excel system running off the final line of the excel sheet generated by forms.
I have a new tenant and forms is using the new GUI
I send some responses inside forms, but the results are not synced/updated inside my sharepoint/onedrive excel sheet automatically.
It will only work if i click on open result in excel inside the webpage, which will then only update my excel in sharepoint/onedrive.
Please advise how i can get it working again.
Thanks
A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Noted on your reply, we will try out the power automate feature then.
Dear Deric,
Thank you for the reply.
Regarding your first concern, "I've used forms for the past 3 to 4 years and it was working all fine until recently."
Previously, there are two ways for forms to sync data to excel workbooks (sync responses in real-time or sync responses only when opening the workbook in Excel for Web).
However, now there is only one way (sync responses only when opening the workbook in Excel for Web) for forms to sync data to Excel workbooks. **** Microsoft has changed the sync process for all forms.
The following official Microsoft blog has mentioned this change for all forms. You can view it for more details.
Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub
Regarding your second concern, based on above, since there is only one sync way, please note that Forms data sync to Excel is currently only available in Excel for the Web, not in Excel desktop apps or mobile apps. In this case, it is normal that you need open the linked workbook only in Excel for Web to see the latest responses.
Introducing Forms data sync to Excel
Regarding your third concern, yes, there is a workaround to sync the latest form responses to the workbook in the real-time. You will need to build a Power automate flow you could check the reply from George on July 4^th^ 2024 as mentioned in the following thread:
Why is my Forms Spreadsheet not syncing until I open it? - Microsoft Community
Appreciate your understanding and patience.
Sincerely,
AJ RAJ| Microsoft Community Moderator
Hi AJ,
Thanks for your response, It is the same result, if i do not click this circled part to open the excel in my browser even when there's new responses, the onedrive file on my desktop will not automatically update. I've used forms for the past 3 to 4 years and it was working all fine until recently. Please find a workaround for me as we use it for our office operations automation daily.
Dear Deric,
Thank you for the reply and screenshot.
I have also tired in the NEW GUI, and you can refer to the screenshot below to sync the form in new workbook:
Appreciate your understanding and patience.
Sincerely,
AJ RAJ| Microsoft Community Moderator
Hi Raj,
Thanks for replying me so quickly. I've done a new form to test, and this is my screenshot of the trying to generate to a new form.
Mine is on a new GUI, so i'm not sure where you want me to generate into a new form.
In the previous version of non updated form, it works, but this doesn't.