Forms to Excel Output After Editing

Copper Contributor

I have a form that outputs to a workbook where data is then run. I needed to add additional questions to the form and now the new responses will not show up in the workbook. When editing the form itself, it indicates that all of the responses still exist, but when I click on the "open in Excel" button, the responses submitted after the form changes are not there. I am not sure if this is relevant but I also notice when I'm on the workbook it says "SharePoint App is also editing." Does anyone know how to sync my answers with the current workbook?

3 Replies

@kumar430 , in general it shall work. "SharePoint App is also editing" means what Excel file is synced with Forms. After you edit the form, app shall add accordingly columns to the table in Excel file (do you have them?). Thus by default it shall work.

 

I have no answer what could be wrong, perhaps it's better to ask Forms community here. That's more on their, not Excel site.

 

@Sergei Baklan The new columns were not created in the excel automatically. Do I need to add the columns myself in order for the new questions to register?

@kumar430 

 

You may try, but I'm not sure that helps. Normally you may add columns to the table even if they are not part of the form. For example, make some calculations on the answers columns.