The default range for data when opening an Excel file is the entire worksheet. However, if the Use Row Above Selected Range for Column Titles check box is selected, the default data range will begin at A2 (row 2). In this case, in the Excel Information window, both the Named Range and Current Value fields will indicate that data starts in row 2.
The starting row is changed from the first to the second only if the current starting row is the top row. Otherwise, no change will be made to the values.
If you clear the Use Row Above Selected Range for Column Titles, both the Named Range and Current Value fields will revert to their previous values on the Entire Worksheet.