Apr 06 2021 09:25 AM
My form does not update the excel sheet when new responses are submitted. I was expecting a live connection that would update the excel, as the form received new responses.
The excel has been added to (for example formulas, added columns, and hidden columns).
Is there a way to update without creating a new excel each time, and therefor losing the formatting that has been added.
Apr 06 2021 09:53 AM
@sdavidson Yes, but start from an Excel file in Teams, from the Insert Menu you can add a form to a specific sheet. This form will update a table on that sheet each time someone submits, and you can add your own columns with calcutations. Sometimes it takes a few minutes.
You can then share the link to the form however you like, choose it as a tab, post a message, send it by email etc.
Apr 07 2021 12:00 PM
Apr 08 2021 08:09 AM
@sdavidson The one I set up to verify is still working.
The only reason I can see that Forms wouldn't appear on the insert menu would be while you have it open in the desktop app rather than the browser/Teams. You can only add these forms in the web client for Excel. I guess if you have it open in an older version of Excel then new data couldn't be inserted as the file becomes locked.
Apr 08 2021 12:45 PM