Excel Services - Large Workbook Error

You may receive one of the following errors when attempting to view an Excel workbook in SharePoint depending on your version of SharePoint:     “This workbook is larger than the maximum workbook size allowed to be opened in the browser.”     “Couldn’t Open the Workbook. Wow, That’s a big workbook. Unfortunately, we can’t…

5

PowerPivot for SharePoint 2010 & SQL 2012 - Refresh in browser fails due to multiple "Process" Data Models in Analysis Services.

    When opening a workbook after a Schedule Data Refresh, the workbook does not open in Excel Services:     This is because after a Scheduled Data Refresh, the “Refresh data when opening the file” is checked.  This is by design, because after a Scheduled Data Refresh, the workbook’s Data Model is updated with…

5