Forum Discussion
Christine Saucedo
Feb 01, 2018Copper Contributor
Forms losing connection with Excel
Morning!
I'm continually having an issue where my form looses it's connection to an Excel workbook saved on a team Share Point page. In the intital phases, I would just recreate the form and the sheet. Now that the form share link has been pushed out to others in our organization, that is no longer a good option.
The excel workbook is not being renamed or moved. Although it would be nice if I could rename or move the workbook, that's not the issue here. Is there any way I can work through the excel workbook to reconnect the sheet?
- anthony leducCopper Contributor
I have the same problem since this morning.
I create a form from my OneDrive (right click - contextual menu - and select form for exel)
It 's open a new form. Add a zone texte. Click on result and click open in excel.
I saw Nothing. the tab Form1 is not here. :-(
- Christine SaucedoCopper Contributor
I actually ended up creating a new workbook from the instructions given here https://techcommunity.microsoft.com/t5/Microsoft-Forms/Open-in-Excel-Error-Cannot-open-Excel-workbook/m-p/115330#M770.
I'm ok with having a new workbook. I was not ok with having to make a new form and change the share links.