Forum Discussion
Sorry, something went wrong - backend Excel file
Hi,
Anyone know how to get around the issue of the backend Excel file for the responses not opening?
Have a couple of forms that have the Sorry, something went wrong message when clicking on the Excel file.
Have raised this with MS but no resolution yet
- Zhongzhong_Li
Microsoft
Hi Rob,
Sorry for the slow response.
Do you still have the problem? I could help you connect with the engineering team.
Do you mind to send your form URL and technical detail for us? It will help us troubleshoot the error.
Regards,
Zhongzhong
- Hi Zhongzhong,
The urls to the two Flows that are having issues are below:
https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEkgRUQVY5V0xTQloxTjhNSFZRTTFRNEVWQUVHUi4u&forceReExport=false
https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEkgRUNTRDMjJJTkFLNlJPRjZXTFQxQjlPNlNOWi4u&forceReExport=false
Technical details are that the Excel file with the responses doesn't open when clicking the "Open in Excel" button.
Thanks- Zhongzhong_Li
Hi Deleted,
I have shared this two URLs to our engineers for further investigation.
Regards,
Zhongzhong
- Qingwen Zeng
Hi Rob, I'm the feature's engineer. I'd like to confirm following things:
1. please the owner of the form to check if the excel file connected to the form exists.
2. What did the owner see when she/he click the "Open in Excel" button? Just "something went wrong" or more detail infomation.
3. Do you really have authorization to the form when you got the error page? If you can go to the form response page and then click the "Open in Excel" button,
that means yes, otherwise, no. If you don't have authorization, you get error page like the screenshot is expected.
The answers of the questions can help me to troubleshoot the issue. And if you'd like to unblock the user asap,
you can ask the owner do the reexport action:
Change the forceReExport value from false to true(remember: it needs form owner to do it):
https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEkgRUQVY5V0xTQloxTjhNSFZRTTFRNEVWQUVHUi4u&forceReExport=true
https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEkgRUNTRDMjJJTkFLNlJPRjZXTFQxQjlPNlNOWi4u&forceReExport=trueThanks,
Qingwen
- Qingwen, we got an error today:
1. please the owner of the form to check if the excel file connected to the form exists. YES
2. What did the owner see when she/he click the "Open in Excel" button? Just "something went wrong" or more detail information. “SOMETHING WENT WRONG”
ERROR ID: 1e76150a-eb89-4516-8a6c-821d1753db15, 2018-10-05 12:27:54Z
3. Do you really have authorization to the form when you got the error page? If you can go to the form response page and then click the "Open in Excel" button,
that means yes, otherwise, no. If you don't have authorization, you get error page like the screenshot is expected. YES, YOU HAVE AUTHORIZATION- Zhongzhong_Li
I have asked engineers to check.
Does the Technical details give you any more clues?
- I uninstalled Office 2016, then reinstalled it from the link found on my home page of Office 365. After that, I have been able to do things I couldn't before, such as export a SharePoint List to Excel. Why did I do the uninstall/reinstall? I learned that when Office 2016 is installed, it needs some kind of SharePoint Foundation component. I couldn't determine if I had it originally, or even if I had it after my reinstallation. But things work better now that I did the reinstall. Even Forms/Flow toy problems are working better now; before Forms/Flow was flaky. I'm still experimenting, but I hope that helps with your situation.
