Microsoft Form not loading to Excel workbook

Question

Hello, I have a Microsoft Form i created a few days ago for work. Within Forms, i can view and edit the responses which have come through. I can share the link, change the theme ..essentially the functionality of Forms works perfectly. However, when click 'Open in Excel' i'm given the message 'Opening Excel Workbook on OneDrive' with a never-ending spinning wheel, nothing ever happens after that. 

I've tried opening the Form in Google Chrome and Internet Explorer but get the same message. HELP! Can't do much with the form if i can't even see the results.

Thanks, Vasima

Answer 1

Hello my name is Kleber I am an independent consultant. I hope I can help you. Follow the instructions below and let me know if it helped you. Below is a video with good tips on Microsoft Forms.

: Please, the owner try the steps

1. Click the "Open in Excel" button to open a page tab.
2. copy the url of the new page, similar to: https://forms.office.com/Pages/RedirectToExcelP...; forceReExport = false
3. change "false" to "true" at the end of the url, such as: https://forms.office.com/Pages/RedirectToExcelP...; forceReExport = true
4. Open the new url in the browser and you will see all the data in a new excel file.

https://youtu.be/wtQbMdqXjxQ

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Kind Regards.

Answer 2

Amazing! It worked! Thank you so much Kleber, really helpful and great video too =)

Regards, Vasima

Answer 3

Glad to have helped you, thanks for the feedback. kind regards