Sorry, something went wrong - backend Excel file

Deleted
Not applicable

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

 

image.png

9 Replies

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.

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-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEk...

https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEk...

Technical details are that the Excel file with the responses doesn't open when clicking the "Open in Excel" button.

Thanks

Hi @Deleted, 

 

I have shared this two URLs to our engineers for further investigation.

 

Regards,

Zhongzhong

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-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEk...forceReExport=true
 https://forms.office.com/Pages/RedirectToExcelPage.aspx?id=U7fLnrmoG0-yBpcWknmKZ4GEDRvUKdZLiKc8OtFEk...forceReExport=true

 

Thanks,

Qingwen

Hi Qingwen,

Thanks for the reply.

I've passed on the questions to owner of the forms and will get back to you when they update me.

Thanks

Rob
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

I have asked engineers to check.