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 result 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.