Forum Discussion
Open in Excel - Error: Cannot open Excel workbook
- Oct 12, 2017
Hi Abhimanyu,
From our service logs, I found that your form was truly created from Excel. I can see the excel file info
{
WorkbookId: "drives/b!QB_j3D3OCkaltV6FsXy_73P0zVPS60tCkV9ozfDI4M-PV311TEftQJ78NF5wGyIo/items/01N6DO3N...",
Origin: "Excel",
Title: "Book1"
}
So I guess you might forget the creation entry of the form. And then the excel file "Book1" might be considered as a useless file and be deleted.
You can reexport your data to a new excel file by the steps:
1. click the button "Open in Excel", it will open a page tab.
2. copy the url of the new page, it looks like: https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=v4j5cvGGr0GRqy180ZNV4u&forceReExport=false
3. change the "false" to "true" in the end of the url, like:
https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=v4j5cvGGr0GRqy180ZN4u&forceReExport=true
4. open the new url in browser then you will see all the data in a new excel file.Hope it will help.
Thanks,
Qingwen
Hi, I'm the engineer of the feature.
As you said, you created the form from forms.office.com, you shouldn't have got a form that connects to an onedrive excel workbook. It's too weird, I need to dig in it to see what happend.
so Could you plese provide the link of your form page? That can help us to find the cause.
Thanks,
Qingwen
Qingwen ZengHi! I am having the exact same problem. My link is https://forms.office.com/Pages/ResponsePage.aspx?id=NXF4KzrKbEi9CvYBX785uPg9cfHcN6tItC8ux92Zgg5UMDVVM1lLVEY1RDQxOEFSOEZVRlAyVEYwRSQlQCN0PWcu
what can I do?