Powerpivot - Workbook reports too big to be opened by browser RRS feed

  • Question

  • We have a workbook, it refreshes alright. But, when we try to open it in the browser (ie 32 ) with silverlight, we get a message workbook to big to open in browser? Whats up with this?
    Tuesday, December 13, 2011 3:23 PM


  • Hi,

    You can try below:

    Go to SharePoint Central Administration –> Application Management –> Manage Service Applications. Find Excel Services Application and open it. It opens Manage Excel Services Application. Click on Trusted File Locations

    Get the menu of http:// and select Edit. Change following items in Edit Trusted File Location. Workbook Properties: Maximum Workbook Size. Set as you want. Note that maximum file size accepted by SharePoint for both Excel and PowerPivot is 2GB

    If this does not work for you as well, please give the detail error message you encounter.

    Challen Fu

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, December 15, 2011 6:23 AM