Row limit for Excel Online?

%3CLINGO-SUB%20id%3D%22lingo-sub-2352202%22%20slang%3D%22en-US%22%3ERow%20limit%20for%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352202%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%20Does%20anyone%20know%20if%20there%20are%20row%20limits%20to%20Excel%20Online%3F%3CBR%20%2F%3EWe%20have%20a%20file%20with%20a%20sheet%20with%2095%2C000%20rows%20and%2012%20columns%2C%20which%20had%20been%20working%20fine%20until%20recently.%20Today%2C%20all%20users%20except%20me%20were%20seeing%20an%20error%20when%20trying%20to%20open%20the%20file%20using%20Excel%20Online%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rafael_Torner_0-1620928634068.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280561iA5F3E9192B4E0990%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rafael_Torner_0-1620928634068.png%22%20alt%3D%22Rafael_Torner_0-1620928634068.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20file%20opened%20fine%20for%20me%20on%20Excel%20Online%2C%20so%20at%20first%20we%20thought%20it%20could%20be%20related%20to%20credentials.%20After%20looking%20into%20it%2C%20we%20noticed%20that%20other%20users%20were%20able%20to%20open%20the%20file%20if%20we%20split%20that%20sheet%20into%20two%2C%20with%2045%2C000%20rows%20each%20sheet.%20This%20works%20as%20a%20workaround%2C%20but%20it's%20a%20bit%20of%20a%20pain.%20Is%20there%20a%20limitation%20on%20the%20rows%2Fcells%20Excel%20Online%20can%20open%20in%20a%20single%20sheet%3F%20And%20if%20so%2C%20is%20there%20any%20way%20to%20override%20it%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance%2C%3CBR%20%2F%3ERafael%20T%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2353482%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20limit%20for%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2353482%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ethe%20limit%20is%20not%20so%20much%20the%20number%20of%20rows%2C%20but%20rather%20the%20overall%20file%20size.%20see%20here%20for%20details%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffile-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018f-415a-b890-5452687b325e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffile-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018f-415a-b890-5452687b325e%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone! Does anyone know if there are row limits to Excel Online?
We have a file with a sheet with 95,000 rows and 12 columns and weighs around 8MB, which had been working fine until recently. Today, all users except me were seeing an error when trying to open the file using Excel Online:

Rafael_Torner_0-1620928634068.png

The file opened fine for me on Excel Online, so at first we thought it could be related to credentials. After looking into it, we noticed that other users were able to open the file if we split that sheet into two, with 45,000 rows each sheet. This works as a workaround, but it's a bit of a pain. Is there a limitation on the rows/cells Excel Online can open in a single sheet? And if so, is there any way to override it?

Thank you in advance,
Rafael T

2 Replies
Hello,

the limit is not so much the number of rows, but rather the overall file size. see here for details:

https://support.microsoft.com/en-us/office/file-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018...

@Ingeborg Hawighorst Thanks for your reply, but I forgot to add that the file size is around 8MB, so well under the 50MB limit SharePoint has.