File size limits for workbooks in SharePoint Online

When you view or upload a file in a documents library in a site such as a team site, you’re using SharePoint Online. Excel Web App, which comes with SharePoint Online, enables you to view and interact with a workbook in a browser window much like you would in Excel. But if a workbook is too big—which means it consumes too much disk space—it either won’t open in a browser window, or it won’t let you edit or refresh data in the browser window.

Whether you can view and interact with a workbook in a browser window depends on several factors, such as how big a workbook is in file size, what your Office 365 subscription includes, and where the workbook resides.

What are the current file size limits for workbooks?

Your file size limits are determined by your particular subscription to Office 365. If your subscription includes Power BI for Office 365, then you’ll be able to open, view, and interact with larger workbooks in a browser window than if you just had SharePoint Online.

If your Office 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-10 MB

Power BI for Office 365

A library in a site such as a team site or in Power BI sites on Power BI for Office 365 (recommended)

0-250 MB

 Important    When a workbook exceeds 30 MB in file size, it must be configured a certain way in order to display in a browser window. See Enable web viewing for a workbook in Power BI for Office 365 sites.

Outlook Web App

Attached to an email message

0-5 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 5 MB to open in a browser window.

What happens if the workbook’s file size is too big?

If a workbook exceeds the file size limit that’s set for your Office 365 subscription, you won’t be able to view it in a browser window. However, there are some things you can try:

Where can I find more information?

To learn more about this… Go here…

How to save files to a library in a site such as a team site in SharePoint Online

Upload files or create files in a library

How to save a workbook to Power BI sites on Power BI for Office 365

Save a workbook to a Power BI site

How to make a large workbook (up to 250 MB) viewable in a browser window in Power BI sites on Power BI for Office 365

Enable web viewing for a workbook in Power BI for Office 365 sites

Limits for workbooks that contain a Data Model Data Model specification and limits

Additional boundaries and limits for SharePoint Online, including numbers of users and overall storage limits across different Office 365 subscriptions

SharePoint Online: software boundaries and limits

Power BI for Office 365 and how to get it

Power BI for Office 365 (overview)

Which Office 365 subscription you have

Contact your Office 365 administrator. This is typically the person who sent you your login credentials when you first logged into Office 365.

 
 
Applies to:
Excel Online, Power BI for Office 365, SharePoint admin center, SharePoint Online Enterprise (E1), SharePoint Online Enterprise (E3 & E4), SharePoint Online Midsized Business, SharePoint Online Small Business