Share via

How to sync with excel from forms

Anonymous
2025-02-03T11:48:03+00:00

Good Morning,

Before the update, we could have the desktop Excel spreadsheet sync with forms, which was updated automatically every time we opened the Excel spreadsheet. Now, the spreadsheet is not updated unless we go to forms and open the spreadsheet (web version), which then updates the desktop Excel.

There is also an error on the desktop Excel "CAN'T SYNC WITH FORMS Please restart Excel or try again later"

Any help on this matter would be greatly appreciated.

Many Thanks

Danielle

Microsoft 365 and Office | Excel | For business | Windows

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.

0 comments
Answer accepted by question author
  1. Anonymous
    2025-02-03T13:23:54+00:00

    Dear Danielle Fluid ,

    I hope this message finds you well.

    Yes, I am experiencing the exact same behavior as you. Recently, there has been a change to the solution for updating Microsoft Forms responses in Excel. According to a Microsoft official article, this is a known limitation at this time. You can refer to the details from the article here ---- >>> Microsoft Forms Blog - Update to the New Solution for Syncing Forms Responses to Excel.

    We understand this may be inconvenient and sincerely apologize for any disruption caused. As a workaround, we recommend posting your feedback on the official Microsoft User Feedback website to help drive improvements and potentially bring back the previous functionality.

    Click here to provide feedback --- >> Ideas · Community

    In the meantime, you may want to explore other alternatives, such as using Power Automate to sync Form responses with Excel or creating an automated export through Flow, which could replicate a similar experience to the previous process.

    You can learn more about the Power Automate workaround by following the steps in this article: Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate - Microsoft Support

    Thank you for your time and patience, we hope you have a great day!

    Kind regards,
    Community Moderator | Sophia

    2 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2025-02-03T14:02:37+00:00

    Thank you so much for your reply.

    I will be leaving feedback, as it is inconvenient the way it is currently set up.

    Thanks again

    Danielle.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2025-02-04T03:08:49+00:00

    Dear Danielle Fluid ,

    I hope this message finds you well.

    If my suggestion helps clarify things for you, please click on the option below.

    Thank you for your time and patience, we hope you have a great day!

    Kind regards,
    Community Moderator | Sophia

    0 comments