Microsoft Forms - move location of Excel file that updates with new answers

Question

I have a Microsoft Form on a page on our SharePoint Intranet and it gathers answers and updates an Excel file automatically. I chose the Sync all responses... option in the form and this worked fine; it created a new workbook in my OneDrive and all new answers are updated in the Excel file.

My problem is that this file is only on my local OneDrive and it needs to be in the document library on the Intranet because it will be monitored by somebody else. I moved the file from where it was created on my OneDrive into one of the folders in the Intranet document library but now it no longer updates, so I presume moving it broke the connection to the Form.

I can't see where I can reconnect it to the Form or change the path of the Excel file from the Forms settings, is this possible? Or is there a different way to move the file without breaking the connection?

Thanks,

David

Answer 1

Dear David,

Good day! Thanks for posting in Microsoft Community. We are happy to help you.

For your question, you can't change the path of the Excel file or reconnect the form with another Excel file, but you can sync all responses to a new workbook which is stored in the Document library of the site. As you are the form owner, to meet your requirement, you need to move the current form to a group (the same name as the site) in Forms. After that, a new workbook will be created in the Document library of the site, and it should have all responses.

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator

Answer 2

I followed this advice for a form I had already created, moved it to a different folder via Teams/Sharepoint Online, and it works perfectly - form submissions update the Excel file in the new directory location. Thank you!