locked
Sharing Large Excel File RRS feed

  • Question

  • I have a large excel workbook file I want to share with multiple users sumutaniously via onedrive.  It is 12meg is size.  It seems Excel online can only handle 5meg.  Any suggestions would be appreciated.
    Monday, March 16, 2015 9:22 PM

Answers

  • Hi,

    Based on your description there was only "OneDrive", I'm still not sure about your scenario. Is it OneDrive(Personal) or OneDrive for Business?

    For OneDrive issues, I suggest you post the question in OneDrive forum:

    http://answers.microsoft.com/en-us/onedrive

    If you are an Office 365 user, 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.

    We can find more information from File size limits for workbooks in SharePoint Online.

    You may also find this blog helpful, which introduces how to increase Excel Workbook Size from the 10 MB Limit on Office Web Apps 2013:http://blogs.technet.com/b/sammykailini/archive/2014/06/25/office-web-apps-2013-increase-excel-workbook-size-from-the-10-mb-limit.aspx

    We can change the ExcelWorkbookSizeMax property to set the workbook size value.

    Regards,

    Melon Chen
    TechNet Community Support


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, March 17, 2015 6:04 AM

All replies

  • Hi,

    Have you tried saving the file as .xlsb (binary) format? This format reduces the filesize with a big chunck. Functionality will remain as .xlsx.

    Maurice


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. Thank You

    Monday, March 16, 2015 9:56 PM
  • Hi,

    Based on your description there was only "OneDrive", I'm still not sure about your scenario. Is it OneDrive(Personal) or OneDrive for Business?

    For OneDrive issues, I suggest you post the question in OneDrive forum:

    http://answers.microsoft.com/en-us/onedrive

    If you are an Office 365 user, 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.

    We can find more information from File size limits for workbooks in SharePoint Online.

    You may also find this blog helpful, which introduces how to increase Excel Workbook Size from the 10 MB Limit on Office Web Apps 2013:http://blogs.technet.com/b/sammykailini/archive/2014/06/25/office-web-apps-2013-increase-excel-workbook-size-from-the-10-mb-limit.aspx

    We can change the ExcelWorkbookSizeMax property to set the workbook size value.

    Regards,

    Melon Chen
    TechNet Community Support


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, March 17, 2015 6:04 AM