Microsoft Forms data sync in excel stopped working

Question

When I open a saved excel response file from Microsoft Forms, the data sync block is no longer active. When I go to 'my add-ins' to add it, it then appears but tells me I need to first create a form, this is when I'm in an excel file saved with form data in.

When I create a new Form and save the excel response file it now gives me the following error messages and after attempting to repair the file it still doesn't work. It doesn't work either if I create a quiz in Forms. Can someone please tell me what has happened since the new features were rolled out?

Thank you

<?xml version= "1.0" standalone="true"?> 
<recoveryLog xmlns= "http:/'schemas.openxmlformats.org/spreadsheetml/2006/main"> 
<summary>Errors were detected in file 'C: 
- cadditionallnfo> 
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. 
</additionallnfo> 
<repairedRecords> 
<repairedRecord>Repaired Records: Table from /xl/tables/table.xml part (Table)</repairedRecord> 
</repairedRecords> 
</recoveryLog>

Answer 1

Hi Liz,

We have received information from related team that Excel "Microsoft Forms data sync" add-in has been retired.

Regarding the two features included in this add-ins,

Score and grading support - it has been supported natively in Microsoft Forms

Data sync support – the team are working on the native support in Microsoft Forms

There is a similar thread in the following forum for your reference:

https://techcommunity.microsoft.com/t5/Microsoft-Forms/DATA-REFRESH-CONNECTION-NO-LONGER-WORKING/m-p/41996#M332

Regards,

Ryan

Answer 2

Hi,

Have followed your steps and I get the same error messages.

The add-in is called Microsoft Forms Data Sync.

I have tried creating both a new form and a new quiz and the same thing happens with both, I get the same error messages.

thanks

liz

Answer 3

Hi Lizzy,

Please share some updates at your convenience.

Regards,

William

Answer 4

Hi Lizzy,

Given this situation, to understand more clear about your environment, please share more information with us.

1. How do you obtain the add-in for Excel?
2. The steps how to deploy the add-in to Excel and start the sync process from Forms service.

Regards,

William

Answer 5

Hi Lizzy,

Based on your description, I understand that the Excel worksheet doesn't sync responses from Forms in Excel. If this is your scenario, please try the steps below to clear the cache files to check if this can be fixed:

1. Type Microsoft Upload Center in the Search box, and then double-click it to open Microsoft Upload Center.
2. Click Settings, and then click Delete Cached Files.
3. Download a new xlsx document from Forms and open it in Excel to check the result.

If the issue, please share more information with us.

1. Regarding"my add-ins' to add it", what's the add-in in Excel you are using to sync data.
2. What if you create a new Form instead of Quiz and open it in Excel?

Regards,

William