Excel Services crashes continuously

You may experience Excel Services crashing continuously after applying a patch to SharePoint 2013. The issue can be resolved by following these steps:   1. Make sure that the account running Excel Services is part of the groups WSS_WPG and WSS_ADMIN_WPG on the SharePoint servers running Excel Services.   2. Open the SharePoint Management Shell…

0

PowerPivot for Excel – “Memory error”

You may receive the following error when attempting a data refresh using PowerPivot for Excel:     Memory error: Allocation failure : Not enough storage is available to process this command. . If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the…

0

PowerPivot Workbooks as a Data Source

We have been seeing some issues with customers using PowerPivot workbooks as a source file in new Excel PowerPivot files.  There are a variety of errors that can arise from this process, and this blog is intended to provide you with some troubleshooting steps to resolve the issue. You may or may not be aware,…


Find large files across multiple SharePoint content databases

Overview: This blog post contains a tool that will query all content databases on a SQL server looking for files of a given extension and size, it will output a report file that can be loaded into Excel for analysis. PowerPivot can lead to some large workbooks being stored on your SharePoint farms, the tool…

0

Excel Services and PowerPivot error: "Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa"

When you open a workbook in the browser using Excel Services and get an error, or when a scheduled data refresh fails in PowerPivot for SharePoint, you may see the following error in the ULS logs: Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa If you…

0

Configuring the MSOLAP data provider version

When you create a data connection to an Analysis Services data source in Microsoft Excel, the¬†Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server (MSOLAP) is used for the data connection. Each version of Analysis Services has its own MSOLAP provider version. Here is a list of versions: MSOLAP.4 – SQL Server 2008 MSOLAP.5…

0

"PowerPivot Management Dashboard ProcessingTimer Job" throws error "User cannot be found”.

Updated 9/22/2015 After migrating from a SharePoint 2010 site using Classic Mode Authentication(default) to SharePoint 2013 site in claims mode (default again) using database attach, you will run into a situation where document authors are not converted to the new claims identities by the migration process. This is not limited to Excel documents, but is…

2

PowerPivot for SharePoint – Error when running PowerPivot Configuration Tool: "The user is not a farm administrator."

You may receive the following error when running the PowerPivot Configuration Tool on a SharePoint application server running PowerPivot for SharePoint:     The user is not a farm administrator. Please address the validation failures and try again.   The user is required to be both a farm administrator and a site collection administrator in…

0

Excel Services – Consuming a SharePoint List using the ListData.svc

Here are the steps I performed to Consume a SharePoint List in Excel Services (SharePoint On Premise): I created a list at this location: http://sp/_layouts/15/start.aspx#/Lists/TomTestList/AllItems.aspx   I then called the listdata.svc from via Excel > Data tab > From Other Sources  > From Odata Feed > http://sp/_vti_bin/listdata.svc I selected my List. I then created a simple…

5

PowerPivot for SharePoint – Server Configuration Check

Every once in awhile, you will get an error where you cannot Slice to the Data Model.  "PivotTable Operation FailedAn error occurred while working on theData Model in the workbook.  Please try again." If this is the case, you will want to make sure PowerPivot is Configured correctly.  To do this, follow the below instructions….

1