Forum Discussion
Abhimanyu Singh
Oct 11, 2017Steel Contributor
Open in Excel - Error: Cannot open Excel workbook
We are facing a typical problem with one of the forms since last one week. We have opened a ticket as well, but no resolution even after 1 week. The only response I am getting from support is, "we ar...
- 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
Zhongzhong_Li
Microsoft
Mar 23, 2018Hi Deleted, the URL only works for the actual form owner.
Could you check if the URL works for the owner.
Thanks,
Zhongzhong
Deleted
Mar 23, 2018Thanks Zhongzhong_Li It does not work for the owner.
- DeletedApr 10, 2018
Qingwen,
Do you have any thoughts on the error I sent you?
Thanks,
Tony
- Qingwen ZengMar 26, 2018
Microsoft
: Please the owner try 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.