Forum Discussion
sdavidson
Apr 06, 2021Copper Contributor
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...
sdavidson
Apr 07, 2021Copper Contributor
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?
Any insight on keeping it connected?
StevenC365
Apr 08, 2021MVP
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.
- sdavidsonApr 08, 2021Copper ContributorThank 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?