Change file threshold to 10MB when editing files using excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-1392781%22%20slang%3D%22en-US%22%3EChange%20file%20threshold%20to%2010MB%20when%20editing%20files%20using%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392781%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20default%20file%20size%20threshold%20for%20editing%20files%20with%20excel%20online%20is%205Mb.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20some%20references%20indicating%20the%20threshold%20can%20be%20increased%20to%2010Mb%20but%20haven't%20been%20able%20to%20clarify%20if%20that%20was%20bogus%20or%20not.%20Suggestion%20was%20a%20setting%20in%20the%20O365%20subscription.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWho%20knows%20if%20the%20change%20from%205MB%20to%2010MB%20threshold%20is%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1392781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414750%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20file%20threshold%20to%2010MB%20when%20editing%20files%20using%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669139%22%20target%3D%22_blank%22%3E%40drareve%3C%2FA%3EI%20think%20the%20default%20size%20is%20up%20to%205MB%20but%20if%20you%20have%20MS%20Office%20365%20Subscription%20it%20is%20up%20to%2010%20MB%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--1350828991%22%20id%3D%22toc-hId--1350828991%22%20id%3D%22toc-hId--1350828991%22%3EWhat%20are%20the%20current%20file%20size%20limits%20for%20workbooks%3F%3C%2FH2%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20file%20size%20limits%20are%20determined%20by%20your%20particular%20Microsoft%20365%26nbsp%3Bsubscription.%3C%2FP%3E%3CP%3EIf%20your%20Microsoft%20365%20subscription%20includes%E2%80%A6And%20the%20workbook%20is%20stored%20here%E2%80%A6Then%20these%20file%20size%20limits%20apply%20to%20workbooks%20in%20a%20browser%20window%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3ESharePoint%20Online%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EA%20library%20in%20a%20site%20such%20as%20a%20team%20site%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0-50%20MB%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3EOutlook%20Web%20App%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EAttached%20to%20an%20email%20message%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0-10%20MB%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20trying%20to%20open%20a%20workbook%20that%20is%20attached%20to%20an%20email%20message%20in%20Outlook%20Web%20App%2C%20a%20smaller%20file%20size%20limits%20applies.%20In%20this%20case%2C%20the%20workbook%20must%20be%20smaller%20than%2010%20MB%20to%20open%20in%20a%20browser%20window.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607757%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20file%20threshold%20to%2010MB%20when%20editing%20files%20using%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402789%22%20target%3D%22_blank%22%3E%40AshaKantaSharma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20not%20modify%20file%20threshold%2C%20but%20when%20the%20file%20was%20created%20it%20was%2077KB%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

The default file size threshold for editing files with excel online is 5Mb.

 

I have seen some references indicating the threshold can be increased to 10Mb but haven't been able to clarify if that was bogus or not. Suggestion was a setting in the O365 subscription.

 

Who knows if the change from 5MB to 10MB threshold is possible?

 

 

2 Replies
Highlighted

@drareveI think the default size is up to 5MB but if you have MS Office 365 Subscription it is up to 10 MB 

What are the current file size limits for workbooks?

 

Your file size limits are determined by your particular Microsoft 365 subscription.

If your Microsoft 365 subscription includes…And the workbook is stored here…Then these file size limits apply to workbooks in a browser window

SharePoint Online

A library in a site such as a team site

0-50 MB

Outlook Web App

Attached to an email message

0-10 MB

If you’re trying to open a workbook that is attached to an email message in Outlook Web App, a smaller file size limits applies. In this case, the workbook must be smaller than 10 MB to open in a browser window.

 

@AshaKantaSharma 

I did not modify file threshold, but when the file was created it was 77KB