Microsoft Forms Not Updating Excel Anymore

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