MS Forms & Excel Data Storage

Hey JoshLynch_Lucid

I think there is some confusion here in regards to how you are using the forms. First off, when you create a form and share its link out, any responses which people mark are collected in the same excel file on office 365 end.

Its just that when you want to see the responses in excel it downloads a new file with updated responses. 

Notice the icon to open in excel, It doesn't have a cloud next to it, that means that the form is not being stored in onedrive/Sharepoint, when you click it, it does download an excel sheet every time since it is not stored in sharepoint, Microsoft probably did it to remove the dependency of having onedrive/sharepoint license to use forms.

If you would like to have the responses stored in a file in sharepoint/Onedrive, you can very well do that. First create an excel file in sharepoint/one drive, now from within the file , click insert and choose form:

Create your form from here, now when you receive responses they will be stored in the same excel file in sharepoint/onedrive:

Thanks