Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

File size limits for workbooks in SharePoint Online

 

Applies to: SharePoint Online Enterprise (E3 and E4), Power BI for Office 365, Office 365 ProPlus, Excel Online, Excel 2013

Topic Last Modified: 2014-03-21

Summary: In Office 365, file size limits are applied to workbooks. When a workbook exceeds a file size limit, it won’t display in a browser window. Users have several options to consider.

SharePoint Online enables people to view and interact with a workbook in a browser window much like they would in the Excel client. However, certain file size limitations apply to workbooks in libraries in Office 365. These file size limits can vary from one person to another, because they are based on the particular Office 365 subscription each person has.

When a workbook exceeds the file size limit that is specified for a particular user, the workbook cannot be viewed in a browser window. In that case, the user has several things to consider:

When someone tries to open a workbook in SharePoint Online, an automatic check is performed behind the scenes in Excel Online. The automatic check determines the workbook’s file size, whether the workbook contains a Data Model, what subscription to Office 365 the user has, and whether a workbook is enabled for web viewing in Power BI for Office 365. Depending on the particular scenario, one of two things happens: the workbook opens in the browser window, or the user receives an error message.

In general, here’s how it works:

 

If the workbook’s overall file size is this And these conditions are met Then this happens

0-5 MB

The workbook is attached to an email message that the user is viewing in app for Outlook Web App.

If the workbook’s overall file size does not exceed 5 MB, the user should be able to open and view the workbook in a browser window. If the workbook exceeds 5 MB in overall file size, the user must open the workbook in Excel.

0-10 MB

The workbook was uploaded to a library in SharePoint Online, and the user has an Office 365 subscription that includes at least SharePoint Online

When the user clicks (or taps) the workbook to open it, the workbook opens in a browser window, where the user can view and interact with the workbook’s contents.

10-30 MB

The workbook was uploaded to a library in SharePoint Online, and the user has an Office 365 subscription that includes at least Power BI for Office 365

When the user clicks (or taps) the workbook to open it, the workbook opens in a browser window, where the user can view and interact with the workbook’s contents.

30-250 MB

  • The workbook was uploaded to a library in SharePoint Online.

  • The user’s subscription includes Power BI for Office 365

  • The workbook contains a Data Model, and content in the workbook outside the Data Model totals 10 MB or less

  • The workbook is visible in Power BI sites, and the workbook is enabled for web viewing

When the user clicks (or taps) the workbook to open it, the workbook opens in a browser window where the user can view the workbook’s contents. However, to edit the workbook or to refresh data, the user must open the workbook in Excel.

More than 250 MB

Not applicable

Workbooks that exceed 250 MB in file size cannot be viewed in a browser window.

Whenever a workbook cannot be displayed in a browser window, users can generally open the workbook in Excel, assuming the user has the appropriate subscription to Office 365.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.