Forms Responses Excel File Corrupt

%3CLINGO-SUB%20id%3D%22lingo-sub-1487229%22%20slang%3D%22en-US%22%3EForms%20Responses%20Excel%20File%20Corrupt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487229%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20that%20Forms%20has%20an%20error%20when%20I%20try%20to%20download%20my%20responses%20in%20an%20excel%20file%20from%20forms.%20The%20file%20size%20out%20of%20forms%20is%2067MB%2C%20but%20when%20I%20trick%20Forms%20and%20force%20it%20to%20only%20download%205000%20rows%20at%20a%20time%20by%20inserting%26nbsp%3B%3CSTRONG%3E%3FDownloadFileSize%3D5000%26nbsp%3B%3C%2FSTRONG%3Edirectly%20into%20my%20HTML%20after%20.aspx%20it%20saves%20two%20files%20that%20are%20around%201.7MB%20each%20or%203.64MB%20when%20I%20manually%20combine%20them%20in%20excel.%20Any%20idea%20what%20could%20be%20causing%20this%20issue.%20It%20looks%20to%20be%20a%20Forms%20Excel%20generation%20error.%20Currently%20I%20have%20the%20excel%20spreadsheet%20linked%20to%20sharepoint%20as%20it%20is%20part%20of%20a%20sharepoint%20team.%20If%20I%20manually%20replace%20this%20excel%20spreadsheet%20in%20sharepoint%20will%20it%20throw%20off%20my%20forms%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Greetings,

 

I believe that Forms has an error when I try to download my responses in an excel file from forms. The file size out of forms is 67MB, but when I trick Forms and force it to only download 5000 rows at a time by inserting ?DownloadFileSize=5000 directly into my HTML after .aspx it saves two files that are around 1.7MB each or 3.64MB when I manually combine them in excel. Any idea what could be causing this issue. It looks to be a Forms Excel generation error. Currently I have the excel spreadsheet linked to sharepoint as it is part of a sharepoint team. If I manually replace this excel spreadsheet in sharepoint will it throw off my forms data?

 

Thank you!

1 Reply

@djmitz6 

Can you share the exact error message that you are getting?