Once you work with Excel On-line workbooks, you need to needless to say if the file is simply too giant it might devour too many assets, resembling reminiscence or disk house, and chances are you’ll not have the ability to open it. And if you’re fortunate sufficient to one way or the other open it then you definately will not be fortunate sufficient to edit it. Your means to open and edit Excel workbooks in SharePoint On-line will depend on a number of elements, resembling the placement of the workbook, the kind of Workplace 365 subscription that you’ve got and, after all, the dimensions of the workbook. For instance, do you know that in case your subscription consists of Energy BI for Workplace 365, you’ve gotten a a lot better likelihood of opening and dealing with an Excel workbook than in case your subscription solely included SharePoint On-line. Why? As a result of whenever you open a file positioned in a group website library of SharePoint On-line, the utmost file add measurement is proscribed to 10 MB. That’s proper, simply 10 MB. Nevertheless, when you retailer a file within the Energy BI service, which would be the case in case your subscription included the Energy BI Professional or Energy BI Free, you’ll be able to work with an Excel workbook that’s as much as 250 MB in measurement.
If you’re working with Energy BI for Workplace 365 (a.okay.a. the earlier Energy BI expertise) and the file is positioned in a library on a group website, or within the Energy BI website, you’ll be able to nonetheless work with a workbook that’s as much as 250 MB in measurement. Nevertheless, in case your workbook is bigger than 30 MB in measurement then it is advisable to configure the workbook in a sure means earlier than you’ll be able to show it within the browser window. Take a look at this text from Microsoft for extra particulars: Allow internet viewing for a workbook in Energy BI for Workplace 365 websites.
One other factor to remember when working with giant Excel workbooks is that Outlook Net App can’t open recordsdata connected to an electronic mail message which can be bigger than 10 MB. If that’s the case, be certain then I counsel you attempt one of many following choices. Let the recipient know that he/she received’t have the ability to open the file connected to the Outlook Net App message and should obtain the file first after which open it in Excel desktop software. The recipient or chances are you’ll not like this possibility. Another choice might be to cut back the dimensions of the file earlier than you connect to a message, if the recipient might be utilizing Outlook Net App to open the file. See the part Learn how to Scale back the Dimension of an Excel Workbook on the finish of this text for extra particulars.
The next chart from gives a abstract of file measurement limits in SharePoint On-line.
| Your Workplace 365 Subscription Consists of | Location of Your Workbook | File Dimension Limits for Workbooks Opened in a Browser Window |
| SharePoint On-line | A library in a SharePoint website | 0-10 MB |
| Energy BI Professional or free | The brand new Energy BI service | 0-250 MB (See subsequent part for extra particulars) |
| Energy BI for Workplace 365
(a.okay.a. the earlier Energy BI expertise) |
A library in a SharePoint website or within the earlier Energy BI websites on Energy BI for Workplace 365 (really helpful) | 0-250 MB
NOTE: Workbooks which can be bigger than 30 MB should be configured in a sure means earlier than it is possible for you to to see them in your browser, as described within the second paragraph of this text. |
| Outlook Net App | Connected to an electronic mail message | 0-10 MB
NOTE: Outlook Net App can’t open Excel recordsdata bigger than 10 MB in a browser window. |
Learn how to Scale back the Dimension of an Excel Workbook
There are a number of issues you are able to do to cut back the dimensions of a big Excel workbook. Photos, clip artwork, textual content containers, shaded cells, and coloured worksheets could make the dimensions of the worksheet bigger than 10 MB. Take away some or all of those customizations to cut back the dimensions of the worksheet. You too can take away information from the worksheets and retailer it within the Knowledge Mannequin. Take a look at the article Scale back the dimensions of an Excel file for extra data.
