Forum Discussion
Real time Microsoft Forms results in Excel Worksheet
SergeiBaklan I already have an online form, and I can open the responses in Excel. But it just shows the responses up to that point. When new responses come in, the Excel spreadsheet does not automatically update. So I have to open multiple worksheets. Is there a way for me to connect an online Excel spreadsheet to the Form, so that it automatically updates? I would prefer not to create a new form.
To my knowledge that doesn't work.
If you create Form from the file saved on SharePoint/OneDrive all responses are collected in this file.
If create new Form without Excel, all responses are collected somewhere on Microsoft servers. With Open in Excel you download them from the server, but there is no connector to automatically pickup data from the server.