When opening an Excel workbook in Excel Services, the message
When you refresh the page (after receiving the above message) you receive the message
Maximum Concurrent Queries Per Session were being exceeded (were set to 5).
The HTTP request that was sent to the IIS server had a request header that exceeded the allowable request header length configured on the IIS server.
*Note: this may require analyzing all ULS from al machines in farm that are Web Front Ends.
Filter under>Excel Services>Excel Services External Data>Information and look for the message:
If you see the above messge browse to Excel Services Settings>Trusted file Locations>Maximum Concurrent Queries Per Session (Increased from Default 5 to 50).
Add the below RegKeys to the WFE and Application Servers and Reboot:
Note: It may be necessary to add the below Registry Key to the Client & Server and Reboot:
New resolution for problems with Kerberos authentication when users belong to many groups
How to force Kerberos to use TCP instead of UDP in Windows
Article ID: 2704254 - Last Review: 15 May 2012 - Revision: 1