Forum Discussion

Copper Contributor

Apr 06, 2021

Forms in Teams

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 ad...

MVP

Apr 06, 2021

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.

sdavidson

Copper Contributor

Apr 07, 2021

Steven Collier Thank you, this seemed to work initially. However, today, we are back to square one. The original excel will not update and I know longer see Forms on the Insert tab, where yesterday I was able to view, edit, and share the form from that tab.

Any insight on keeping it connected?

StevenC365
MVP
Apr 08, 2021
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.
- sdavidson
  Copper Contributor
  Apr 08, 2021
  Thank you. I can still see the forms now, but when I click the form, it now says New Form as my only option. Would it break if I tried to sync a new excel? Should I try the process again?