Forum Discussion
Open in Excel - Error: Cannot open Excel workbook
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
MicrosoftHi, 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 Zeng wrote: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
Thank you Qingwen Zeng for responding. Please note the link to that form: https://forms.office.com/Pages/DesignPage.aspx?fragment=FormId%3DkgmvRZbbx02k80dN7-wYrfbYZsc6ejFEsm9xgTf9GVFUN0ZSRVFLNjA0OFRWRFlYNVhOVU1CUVFLVi4u%26Token%3Dca7aba2f39164b2ab1c698db30398fc9
Yes this is very weird. As I said, I already opened a support ticket, but until now they haven't been able to do anything. The ticket Id is SRX1400328584ID.
I told them that if they need more time, then at least give an extract of raw data from the unerdlying database, so that I can get on with business. But even this is not happening and I am getting a flak every passing day!
- Qingwen Zeng
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
Thanks a lot Qingwen Zeng for your efforts.
1. I talked to the user who created this form, and she is sure about the process she took to create it. In fact, when I gave the training I never talked about Excel Survey via OneDrive. I only showed them how to login to forms.office.com and create forms there. During the support ticket calls, I asked her to show me how did she create the form step-by-step. And this dummy form did not have problems, but the process was the same. So, it definitely is weird. (Two entry points to the same service is anyways confusing and redundant, but that is another story and rant for another day.)
2. I tried the method you suggested of turning the "forceReExport" querystring to "true". But this also does not work, and throws another error:
Error when forceReExport is set to true
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?
Thank you Qingwen Zeng for all your support. Much appreciated. I could get the export done with your help. Marked it as closed.
