Sign in
Excel Services & PowerPivot for SharePoint
Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Blog Home
OK
RSS for comments
RSS for posts
Atom
Search
Tags
2013
An error has occurred trying to perform the requested action
An error occurred
An error occurred while capturing snapshots of this document
Application Pool
Constrained Delegation
Excel Services
External Data Refresh Failed
Failed to Refresh
Gallery
Getsnapshot.exe
HTTP 400
Icons
IIS
KDC_ERR_ETYPE_NOTSUPP
Kerberos
PowerPivot
PowerPivot for SharePoint
PowerPivot Gallery
Red X
SharePoint 2010
SharePoint 2013
Snapshot
SQL
thumbnails
Monthly Archives
Archives
May 2013
(2)
April 2013
(3)
February 2013
(5)
January 2013
(2)
December 2012
(4)
TechNet Blogs
>
Excel Services & PowerPivot for SharePoint
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Excel Services & PowerPivot for SharePoint
Excel Services - The workbook cannot be opened.
Posted
1 day ago
by
Tom S - MSFT
0
Comments
When opening an Excel workbook (.xlsx) in the browser the error " The workbook cannot be opened " is thrown: This is caused by the account running Excel Services not having proper permissions to the Content Database. When you upload an Excel workbook...
Excel Services & PowerPivot for SharePoint
PowerPivot Scheduled Data Refresh - Call to Excel Services Returned and error.
Posted
14 days ago
by
Tom S - MSFT
1
Comments
I have encountered the error " Call to Excel Services returned an error " when performing a Scheduled Data Refresh. In several cases, this has been because the PowerPivot connection is using the " SQL Server Native Client " Provider. We recommend...
Excel Services & PowerPivot for SharePoint
Error attempting to create new PowerPivot Gallery Document from PowerPivot gallery
Posted
1 month ago
by
Jason Sc - MSFT
2
Comments
With SharePoint 2010, you might run into an issue when attempting to create a new PowerPivot Gallery Document from PowerPivot gallery, like this: If you encounter this issue, you may then see the following to errors: The reason for the...
Excel Services & PowerPivot for SharePoint
PowerPivot for SharePoint Manual Data Refresh Failing
Posted
1 month ago
by
Jason Sc - MSFT
2
Comments
You might see a scenario where data refresh with PivotTables or slicers or Data > Refresh All Connections are not working, and you are seeing an error in the browser like this: You may also find a corresponding error in the SharePoint logs like...
Excel Services & PowerPivot for SharePoint
3 Things you may/may not know about PowerPivot-AS for SharePoint 2013
Posted
1 month ago
by
Tom S - MSFT
0
Comments
The following applies to SharePoint 2013: 1. Restarting ECS will force a wipe and reload of PowerPivot databases. 2. Any service account needing to interact with the PowerPivot data model needs to be an Administrator on the PowerPivot AS instance...
Excel Services & PowerPivot for SharePoint
PowerPivot Workbooks as a Data Source
Posted
3 months ago
by
Dan F. - Microsoft Support
0
Comments
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...
Excel Services & PowerPivot for SharePoint
Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint
Posted
3 months ago
by
Tom S - MSFT
0
Comments
I have troubleshot many Kerberos cases over the years and here are the best techniques and tools that I have used over the years. 1. Kerberos Event Logging (KB here ): Add the following registry value to each machine in the farm that receives Kerberos...
Excel Services & PowerPivot for SharePoint
Excel Web Access WebParts fail to refresh in Team Foundation Server Dashboard.
Posted
3 months ago
by
Tom S - MSFT
1
Comments
I have worked with many customers who are seeing refresh failures in the Excel Web Access Web Parts in their TFS Dashboard. In most cases, this is caused by not having a Secure Store Service ID set up for Team Foundation Server and that SSS ID has...
Excel Services & PowerPivot for SharePoint
Excel Services Data Refresh Failed. Kerberos.dll bug (Server 2008 pre R2).
Posted
3 months ago
by
Tom S - MSFT
0
Comments
I have had several cases where a customer will have Kerberos properly configured but refresh in the browser fails. In the UI, the error will appear. "Unable to get the required information about this cube. The cube might have been reorganized or...
Excel Services & PowerPivot for SharePoint
PowerPivot 2013 - Refreshing External Data (SQL 2012) in the Browser
Posted
3 months ago
by
Tom S - MSFT
3
Comments
When refreshing in the browser you may come across this error: "External Data Refresh Failed An error occurred while working on the Data Model in the workbook. Please try again. We were unable to refresh one or more data connections in this workbook...
Excel Services & PowerPivot for SharePoint
PowerPivot for SharePoint - Browser Refresh Fails (Data Refresh not supported in Office Web Apps)
Posted
3 months ago
by
Tom S - MSFT
0
Comments
We have been seeing Excel Services/PowerPivot data refresh issues using SharePoint 2013 and Office Web Apps (OWA). Some customers have been running into issues when attempting to refresh data in a PowerPivot workbook on SharePoint 2013 using OWA server...
Excel Services & PowerPivot for SharePoint
Excel Services 2010 - "Unable to process the request." Maximum Private Bytes size exceeded. Unable to complete the operation.
Posted
3 months ago
by
Tom S - MSFT
0
Comments
Issue: ========== Unable to render a workbook in the browser: Unable to process the request - Wait a few minutes and try performing this operation again" Cause: ========== According to the ULS logs, you are exceeding you “Maximum...
Excel Services & PowerPivot for SharePoint
Excel Services & F5 - Excel Web Access Web Parts Not Rendering.
Posted
4 months ago
by
Tom S - MSFT
0
Comments
I have worked with several customers who were experiencing strange behavior when viewing a SharePoint Dashboard containing multiple Excel Services Web Parts. In one support case, a customer had 16 Excel Web Access Web Parts. Some users would see all...
Excel Services & PowerPivot for SharePoint
PowerPivot for SharePoint - Gallery Thumbnails Not Rendering
Posted
4 months ago
by
Tom S - MSFT
0
Comments
Many customers have reported after uploading a workbook to the PowerPivot Gallery, the thumbnails are not rendering: Snapshots will not work if you have chosen to open the workbooks in the Client application. To remedy this, follow the below instructions...
Excel Services & PowerPivot for SharePoint
PowerPivot for SharePoint - Scheduled Refresh to Oracle, IBMDB2, SQL (en-US)
Posted
5 months ago
by
Tom S - MSFT
0
Comments
PowerPivot for SharePoint - Scheduled Refresh to Oracle, IBMDB2, SQL (en-US) Here is how to create a Scheduled Refresh to an Database that does not accept domain credentials in PowerPivot: Create 2 SSS IDs: 1. PowerPivotDataRefresh a...
Excel Services & PowerPivot for SharePoint
Invoking and Analyzing the Getsnapshot.exe
Posted
5 months ago
by
Tom S - MSFT
2
Comments
Hello Everyone, We have seen an increase in PowerPivot Thumbnail issues. If my blog does not resolve it. You will need to manually invoke the Getsnapshot.exe, rename the “thumbnails.info” file that is generated on the desktop to “thumbnails...
Page 1 of 1 (16 items)