Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
File size limits for workbooks in SharePoint

Microsoft SharePoint has some file size limits for workbooks. When you upload an Excel for the web workbook to a SharePoint document library that's too large, it will either not open in a browser window, or let you edit or refresh data in the browser. To keep from consuming too much disk or memory space, Microsoft 365 SharePoint puts some file size limits on the files or workbooks you can upload and work with online.

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 Microsoft 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 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-100 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.

If you are using Excel for the web and Power BI, different file size limits apply. For more information, see Data storage in Power BI and Reduce the size of a workbook for Power BI.

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

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

  • If you have Excel installed on your device, you can download the workbook and then open it in Excel.

  • If you have edit permissions to the workbook, you can try to reduce the workbook's file size.

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

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 Microsoft 365 subscriptions

SharePoint Limits

Which Microsoft 365 subscription you have

Contact your Microsoft 365 administrator. This is typically the person who sent you your work account when you first logged into Microsoft 365.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×