“The service is unavailable” error when you try to use a REST URL to open an Excel workbook

Symptoms

You try to open a Microsoft Excel workbook on a web server by using a representational state transfer (REST) URL that resembles the following URL:

http://Server01/_vti_bin/ExcelRest.aspx/documents/REST.xlsx/Model/Ranges('Finance')
?$format=html&Ranges('Test1')=7448&Ranges('Test2')=3/31/2013&Ranges('Test3')=12345&
Ranges(‘Test4')=67890&Ranges('Test5')=98765&Ranges('Test6')=54321&Ranges('Test7')=3434&
Ranges('Test8')=3434&Ranges('Test9')=555&Ranges('Test10')=11&Ranges('Test11')=12
However, you receive the following error message in the browser window:

The service is unavailable

Cause

This behavior occurs because the REST URL uses 11 cells when it makes a single REST call. The maximum number of cells into which a value can be inserted for a REST call is 10. This is by design.

If you capture ULS logs, you find that the following error is logged:

0x236C Excel Services Application 
Excel Calculation Services
a4lw
Medium
ModelResource.CreateServerSession: The REST call made is above the limit of allowed values to set to the workbook (limit is 10)

Workaround

To work around this behavior, use 10 or fewer cells when you make a single REST call.

Status

This behavior is by design.
Proprietăți

ID articol: 3123359 - Ultima examinare: 4 ian. 2016 - Revizie: 1

Excel Services in SharePoint Server 2013, Excel Services in Microsoft SharePoint Server 2010

Feedback