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 All
We are experiencing the same issue and updating the URL from "False" to "True" did not work for us. Was there something different that you did in order to get this to work?
Hi Tony,
Are you the form owner?
And could you share the form url to me?
Thanks,
Qingwen
- DeletedMar 21, 2018
Thanks for the quick response! Here is the link to the form https://forms.office.com/Pages/ResponsePage.aspx?id=Bivvv1bSjk-9A402h5hwY8jvYnBAiBZMkaODyhv0pJRUQUI5WUJWRjA0WDNQRUFPUDdOUlVSTzZQTy4u
We don't have external sharing enabled at this time so if that poses a problem in your investigation, please let me know
Thanks!
- Zhongzhong_LiMar 23, 2018Microsoft
Hi Deleted, the URL only works for the actual form owner.
Could you check if the URL works for the owner.
Thanks,
Zhongzhong
- DeletedMar 23, 2018
Thanks Zhongzhong_Li It does not work for the owner.