Forms not updating Excel

Question

Hi,

I have connected a Microsoft forms responses to an Excel, However in that excel sheet, I want to add a new column to the table that is created from the form filled data. However, adding a new column to the table seems to have broken the form

(New entries no longer get updated, all I get is the notification that app,sharepoint made some changes but when I open and refresh everything I get nothing)

The sheets are no longer being updated with the new responses.
How do I create a new form that accommodates this purpose.

The new column is a user entered value, and I HAVE to find a way to incorporate it into the excel sheet table.

Answer 1

Dear Varun Shankar1,

Good day! Thank you for your reply to Microsoft Community. We are happy to help you.

From your description, Forms not updating Excel.

Please follow the steps

• You can go to SharePoint Document library > create Forms for Excel, then the data will be filled into Excel file automatically when adding new question or new responses in form.

• Open the form and go to "Responses" page >> click 3 dots >> click "sync all responses to a new workbook", this will generate all responses to a new workbook, and all the new responses will be added to this workbook later.

If the scenario above is not consistent with yours, you can also post back and point that.

You mentioned "I have connected a Microsoft forms responses to an Excel", could you provide the detailed steps about how you connect Form and Excel file?

Have a nice day!

Answer 2

The problem is that I've already created the form using OneDrive--so how can I move to Sharepoint in order to continue to receive updates from the form into the spreadsheet?