Share via

Microsoft Forms Not Updating Excel Anymore

Anonymous
2022-12-19T04:32:21+00:00

Hi, my MS Forms used to update an Excel workbook automatically. However, I cannot get it to sync real-time anymore. I'm on an E1 license. Please help, thank you.

Microsoft 365 and Office | Microsoft Forms | For business

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-19T05:40:09+00:00

    Dear AiPingC,

    Greetings! Thank you for posting in Microsoft Community. We are happy to help you.

    As per your description, your Microsoft Forms doesn't update an Excel workbook automatically.

    Since you mentioned the form used to update an Excel workbook, may I know if your form was created from OneDrive for business or SharePoint Online or Excel for the web or Microsoft Teams?

    If so, you may try to sync all responses to a new workbook with steps below:

    (If our understanding of the scenario is not consistent with yours, feel free to point it out)

    Open the Form, go to Responses tab, click the 3 dots and choose Sync all response to a new workbook, click OK when it asks Proceed? You may refer to screenshots below.

    A new workbook will open in Excel with your most up-to-date responses. This new workbook will be stored next to your original workbook on OneDrive for business or SharePoint Online.

    Per our test, the new workbook still contains a live data connection to form and will get new data.

    Here is an article for reference: How to get missing data in Forms - Microsoft Support

    However, if the new workbook generated from "Sync all responses to a new workbook" doesn't get new data automatically, we're afraid your Form may need to be checked from back end to do further investigation and find root cause of the issue. The best way to investigate the situation further is reporting it to the related team.

    Therefore, we sincerely recommend you contact your Microsoft 365 administrator, follow steps in this article, raise a support ticket and contact related team.

    The support team will help you check the form from back end, they have higher permission to remotely assist you and they may collect fiddler logs to look for root cause. This would be the most efficient way in handling this case for you.

    For reference: How do I find my Microsoft 365 admin? - Microsoft Support

    Thanks for your cooperation and understanding! Hope you keep safe and healthy always.

    Sincerely,

    Tina | Microsoft Community Moderator

    0 comments