Unable to sync Forms

Question

Good morning,

If I edit the grades for a Forms quiz, the grades are not edited in the linked Excel file. Is this happening to you? However, if I download an Excel copy then the modification is updated.

It's very annoying to automate the results.

Thanks![](https://learn-attachment.microsoft.com/api/attachments/6dfd583f-85a7-4435-80ff-ee2fcb5497dd?platform=QnA

Answer 1

Hello, Fabien MIETURKA

Thanks for your reply.

We tested again here. Unfortunately, we are unable to reproduce your issue.

I again recommend that you send feedback to Forms so that they can check if there is an issue with your account.

Thanks again for your patience.

Best wishes, 

Lucia Wu - MSFT | Microsoft Community Support Specialist

Answer 2

Hello and thank you for your response.

The next answers I will do in the form.

Unfortunately, even after several hours, synchronization does not take place By downloading a copy the synchronization is done as you specified but this does not interest me because I have automated many formulas and statistics with the Excel results file.

Thank you so much

Answer 3

Hello, Fabien MIETURKA

Welcome to Microsoft Community.   

I realize that you have encountered a problem that the result of the Forms quiz won't automatically update in Excel, and I understand how you feel. 

We've tried to replicate the issue here.

I would like to explain to you that the synchronization of results takes some time. What you might be experiencing is a synchronization delay issue.

• When we directly click on Excel file (red box 1 in the above picture), it does not update immediately. but after waiting for a few minutes, the results will be automatically updated in Excel files.
• When we click on "Download a copy" (red box 2 in the above picture), because this should generate a new file based on the current Forms results, you can immediately see the updated results.

So, please wait for a while and see if the Excel files is updated.

If the results still do not update after waiting, please click "Disconnect and sync to a new ...“. (bule box in the above picture).

It will generate a new Excel file. When you click on Excel file (red box 1 in the figure) again, you can see the Excel file with the latest results.

Additionally, I sincerely suggest you send your feedback in Forms to let the Forms team know the inconvenience cuased by the delay of result sync.

Thanks for your understanding and cooperation.

Best wishes, 

Lucia Wu - MSFT | Microsoft Community Support Specialist https://learn-attachment.microsoft.com/api/attachments/c3f7387c-17a3-4e04-903a-150b4e2bf8c6?platform=QnA