Microsoft Forms export

[theYaniac]

Is it possible to connect a new excel workbook via Power Query without disrupting the sync file from a Microsoft Forms export? I have a vehicle insoection form for work that is built in MS Forms on our sharepoint. In the export file I added another sheet and put a pivot table on it and seems to have messed up/broken the sync from the export. I was unable to find anything specific online for this particular question. Just curious if it is possible to build a separate sheet and connect the Fomrs export file via a power query. Any suggestions would be greatly appreciated.

 

[ExcelToDAX]

Did you create this form directly within Excels Insert > Forms > New Form like the screenshot?

 

[theYaniac]

No, it was created at Forms.office.com and link posted in our SharePoint. The export comes out as an excel table

 

[ExcelToDAX]

You will have to restart the form directly from Excel so you don't have those issues. When you start it directly in Excel, it will always be that specific Excel file. BTW I saw you are from Michigan and talking about vehicle inspection... we must be at very similar companies since I am in the same state working for a similar company!

 

[theYaniac]

This resolved my issue. Thank you very much