17000 responses and multiple excel sheets have stopped downloading

Copper Contributor

We have over 17000 responses which amounts to four excel sheets that we download when we want to view results. Yesterday, Forms would download excel sheet #1, but hangs up on #2 and times out. How do we get those other excel sheets to download? 

3 Replies

Hi @JoeDavis

 

Just wanting to confirm, do you have one Form with 17000 responses so far, or do you have four Forms and you need to download all four Excel spreadsheet results?

 

Have you tried a different web browser to download (e.g. Chrome)?

 

A work around could be to maybe try creating your Form in Excel which will save it to your OneDrive for Business account. Then you can access the Excel spreadsheet anytime you want as the results will download to there when new responses are fielded.

 

You can do this by going into OneDrive for Business via Office 365 in your web browser, click onto + New and Forms for Excel. Give it an appropriate name and click Create. You'll be taken to the new form ready to create what you need.

 

Untitled.png

 

You can also find the Excel file in the location that you had created it and in the name that you have given it.

 

Best wishes with your issue. Let me know how you go with the options above?

 

Cheers

Damien