In this post, you’ll learn about the error message “SpecifiedRangeNotFound – The requested range does not exist in the sheet.” 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.
SpecifiedRangeNotFound – The requested range does not exist in the sheet.
Reason for the Error
The range that was passed into a method with the A1 suffix (SetCellA1, SetRangeA1, GetCellA1, and GetRangeA1) could not be found.
Make sure the range specified exists in the sheet.