Can I re-establish a connection between a Form and a linked Excel spreadsheet
We have an MS Form through O365 which is linked to an Excel sheet in Sharepoint. Each form entry has been automatically added to the next row of the Excel.
It appears that some manual modifications within the Excel have caused the connection between the Excel and the Form to be broken. New entries are not auto-populating in the Excel.
Can anyone provide a way to reconnect the form to the existing spreadsheet that has been receiving form submissions? I know I can link a new Excel, but we have years of data in the old one, and really want to re-establish the broken connection.
Help!
We have an MS Form through O365 which is linked to an Excel sheet in Sharepoint. Each form entry has been automatically added to the next row of the Excel.It appears that some manual modifications within the Excel have caused the connection between the Excel and the Form to be broken. New entries are not auto-populating in the Excel. Can anyone provide a way to reconnect the form to the existing spreadsheet that has been receiving form submissions? I know I can link a new Excel, but we have years of data in the old one, and really want to re-establish the broken connection.Help! Read More