SharePoint Excel Services RangeRequestAreaExceeded – The area of the requested range exceeds 1,000,000 cells.

In this post, you’ll learn about the error message “RangeRequestAreaExceeded – The area of the requested range exceeds 1,000,000 cells.” that you usually receive when working eith the Excel Services in SharePoint.

When working with SharePoint Excel Services, there are error codes that are generated in the SOAP exception when the errors occur in the Excel Services. You can use the SubCode property that is available in the SoapException class to identity these error codes and troubleshoot the issue.

Error Message

RangeRequestAreaExceeded – The area of the requested range exceeds 1,000,000 cells.

Reason for the Error

The requested range exceeds the 1,000,000 cell limit.

Solution

To return ranges that contain more than 1,000,000 cells, use multiple calls.