Description
The specified cell range is outside the sheet's data extent.
This error is encountered when a cell range is specified that begins at a column to the right of, or a row below, the extent of cells containing data. A cell range that includes row 0 will also produce this error, since the cell range begins with row 1.
For example, the error will occur if the spreadsheet contains data in the range A1:G10 and the following cell range is entered:
- X10:Z20—This is to the right of the extent of cells with data.
- B50:C60—This is below the extent of cells with data.
Solution
Open the Excel spreadsheet and confirm that the specified cell range is correct, or run the tool without specifying a cell range.