Forms losing connection with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-151249%22%20slang%3D%22en-US%22%3EForms%20losing%20connection%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151249%22%20slang%3D%22en-US%22%3E%3CP%3EMorning!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20continually%20having%20an%20issue%20where%20my%20form%20looses%20it's%20connection%20to%20an%20Excel%20workbook%20saved%20on%20a%20team%20Share%20Point%20page.%20In%20the%20intital%20phases%2C%20I%20would%20just%20recreate%20the%20form%20and%20the%20sheet.%20Now%20that%20the%20form%20share%20link%20has%20been%20pushed%20out%20to%20others%20in%20our%20organization%2C%20that%20is%20no%20longer%20a%20good%20option.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20excel%20workbook%20is%20not%20being%20renamed%20or%20moved.%20Although%20it%20would%20be%20nice%20if%20I%20could%20rename%20or%20move%20the%20workbook%2C%20that's%20not%20the%20issue%20here.%20Is%20there%20any%20way%20I%20can%20work%20through%20the%20excel%20workbook%20to%20reconnect%20the%20sheet%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-151249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151274%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20losing%20connection%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151274%22%20slang%3D%22en-US%22%3E%3CP%3EI%20actually%20ended%20up%20creating%20a%20new%20workbook%20from%20the%20instructions%20given%26nbsp%3Bhere%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FOpen-in-Excel-Error-Cannot-open-Excel-workbook%2Fm-p%2F115330%23M770%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FOpen-in-Excel-Error-Cannot-open-Excel-workbook%2Fm-p%2F115330%23M770%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20ok%20with%20having%20a%20new%20workbook.%20I%20was%20not%20ok%20with%20having%20to%20make%20a%20new%20form%20and%20change%20the%20share%20links.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151264%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20losing%20connection%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151264%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20problem%20since%20this%20morning.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20create%20a%20form%20from%20my%20OneDrive%20(right%20click%20-%20contextual%20menu%20-%20and%20select%20form%20for%20exel)%3C%2FP%3E%0A%3CP%3EIt%20's%20open%20a%20new%20form.%20Add%20a%20zone%20texte.%20Click%20on%20result%20and%20click%20open%20in%20excel.%3C%2FP%3E%0A%3CP%3EI%20saw%20Nothing.%20the%20tab%20Form1%20is%20not%20here.%20%3A(%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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? 

2 Replies
Highlighted

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. :(

 

 

Highlighted

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

 

I'm ok with having a new workbook. I was not ok with having to make a new form and change the share links.