TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Excel Services & PowerPivot for SharePoint
Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.
Tags
2010
2013
AJAX
An error occurred
An error occurred while capturing snapshots of this document
bad request
BIG IP
BISM
BISM Icon Missing
black background
blacking out
blank
browser
Call to Excel Services returned an erorr
configuration
Constrained delegation
Couldn't Open the Workbook
Dashboard
Data Connetions
Data Model
Data Refresh Failed
Data Refresh Fails
Delegation
email
Enterprise Application Definition
Excel Services
Excel Web Access web part
Excel Web Access Web Parts
External Data Refresh Failed
fail
Failed to Refresh
Fails
failure
Farm Solutions
feature.xml
Getsnapshot.exe
How to Configure Kerberos for Excel Services
IBMDB2
Icon
Icons not rendering
IE 11
Install
Interactive Refresh
Kerberos
Kerberos Configuration for Excel Services
Kerberos.dll
List
list template is not installed in this farm
Loading
Maximum Private Bytes Exceeded
missing
MSOLAPDisco.3
not working
Notification messages of data update failure are not sent
Office Web Apps
Office Web Apps 2013
OLEDBConnection::InitConnection: The following system error occurred: The function requested is not supported
performance point
PowerPivot
PowerPivot 2013
PowerPivot for SharePoint
PowerPivot Gallery
PowerPivot Management Dashboard Processing Timer Job
PowerView
PowerView Fails to Open
Process
Recycle
Red X
refresh
Refresh all Connection
Refresh Fails
Refresh in Browser
rsClaimsToWindowsTokenError
Schedule Details
Scheduled Data Refresh
Secure Store
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint List
Shutdown was initiated due to an error
SnapShot
Snapshots
SPNs
SQL
SQL Credentials
SQL Reporting Services
SSS ID
Supression
Team Foundation Server
Teradata
The workbook cannot be opened
ThisWorkbookDataModel
thumbnails
Unable to complete the operation
Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The PivotTable was not refreshed
Unable to Process the Request
Unable to refresh data
What is PowerPivot
What is PowerPivot for SharePoint
Browse by Tags
TechNet Blogs
»
Excel Services & PowerPivot for SharePoint
»
All Tags
»
excel services
Related Posts
Blog Post:
Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer)
Jason Sc - MSFT
Issue In some scenarios, an Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer). Instead of seeing the published workbook contents in the web part, there is just a placeholder icon where the workbook should be displayed, and...
on
19 Dec 2014
Blog Post:
Excel Web Access Web Parts & Remote Blob Storage - "We don't know what happened, but something went wrong."
Tom S - MSFT
We have seen several cases where customers can view an Excel Workbook in the browser, but not in the Excel Web Access Web Part. They are seeing the below error in the Excel Web Access Web Part: “Excel Services We don’t know what happened, but something went wrong. Could...
on
8 Dec 2014
Blog Post:
Excel Services - Workbook background is blacking out\workbook is turning black.
Tom S - MSFT
I have seen several cases where the background\parts of Excel workbooks are turning black: Here is an example in the browser: Here is an example from the PowerPivot Gallery: From my experience the W3WP.exe is growing in size and this causes issues with performance. Many times this is the...
on
17 Sep 2014
Blog Post:
Excel Services Data Refresh - Using Secure Store with SQL Credentials.
Tom S - MSFT
This case may be a one-off, but I wanted to write about it in the event someone else comes across it in the future. Here is the synopsis. A user was creating an Excel workbook in the rich client using " Use Windows Authentication ": When you do that, the connection string looks like...
on
28 Aug 2014
Blog Post:
When must I reboot a server running Excel Services?
Tom S - MSFT
I have seen the below errors that required a server reboot to fix the issue: Error in GUI: Error in ULS: 03/06/2014 17:43:45.29 w3wp.exe (0x3B38) 0x574C Excel Services Application Excel Calculation Services 89rs Exception ExcelServerApp..ctor: An unhandled exception occurred during boot....
on
26 Mar 2014
Blog Post:
Excel Services Fix - "The workbook cannot be opened".
Tom S - MSFT
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 to a SharePoint library, the workbook is stored...
on
21 May 2013
Blog Post:
3 Things you may/may not know about PowerPivot-AS for SharePoint 2013
Tom S - MSFT
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. This is less obvious when you are in a client application...
on
2 Apr 2013
Blog Post:
Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint
Tom S - MSFT
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 Traffic: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet...
on
8 Feb 2013
Blog Post:
Excel Services - Query Warning
Zakir H - MSFT
You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint: Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries? To suppress this and other warnings from Excel Services, go...
on
22 Oct 2013
Blog Post:
Excel Services 2010 - "Unable to process the request." Maximum Private Bytes size exceeded. Unable to complete the operation.
Tom S - MSFT
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 Private Bytes” for some unknown reason. The...
on
24 Jan 2013
Blog Post:
What is PowerPivot for SharePoint? Part 2.
Tom S - MSFT
Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In " What is Power Pivot for SharePoint? Part 1 " I discussed the Data Model and how it is a database inside of Excel. When you publish/upload a regular Excel workbook to SharePoint...
on
10 Oct 2013
Blog Post:
Excel Services Data Refresh Failed. Kerberos.dll bug (Server 2008 pre R2).
Tom S - MSFT
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 changed on the server. The PivotTable was not refreshed...
on
4 Feb 2013
Blog Post:
PowerPivot 2013 for SharePoint - "External Data Refresh Failed" using Interactive Data Refresh via "Use the authenticated user's account"
Tom S - MSFT
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. The following connections failed to refresh...
on
1 Feb 2013
Blog Post:
Excel Services - Large Workbook Error
Zakir H - MSFT
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...
on
13 Aug 2013
Blog Post:
Excel Services 2010 & 2013 - Kerberos Configuration
Tom S - MSFT
Configuring Kerberos for Excel Services is a two step process; Information Gathering and Configuration. Step 1: Information Gathering: 1. Account running " Excel Services Application Web Service Application ": In this example: ECSSvc . Central Administration > Security > Configure service...
on
6 Nov 2013
Blog Post:
Upsizing PowerPivot 2013 Workbooks to SSAS for Knowledge Workers
Warren_R_Msft
Much of the existing content for converting a PowerPivot workbook to a SQL Server Analysis Services (SSAS) tabular instance assumes that the reader is a developer. This post details the process of upsizing a PowerPivot workbook to SSAS from the point of view of a knowledge worker and or a SharePoint...
on
23 May 2013
Blog Post:
Excel Services 2013 issue with IE 11.0.9600.16438 - UPDATE
Dan F. - Microsoft Support
There appears to be an issue with SharePoint 2013 Excel Services when using IE 11 (11.0.9600.16438). As noted in the comments below, the issue is resolved by installing the October 2013 Cumulative Update for SharePoint 2013: Description of the SharePoint Server 2013 cumulative update package...
on
21 Nov 2013
Blog Post:
Excel Services & F5 - Excel Web Access Web Parts Not Rendering.
Tom S - MSFT
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 16 Web Parts and others would only see 15. The...
on
27 Dec 2012
Blog Post:
Excel Services - Using a SharePoint List as a data source
Tom S - MSFT
Since Excel Services inception (SharePoint 2007) users have been attempting to consume a SharePoint List in Excel Services. Unfortunately this is not supported. I will explain why and I will also provide a workaround using PowerPivot. If you are unsure whether or not you are using a SharePoint list...
on
11 Jul 2013