Specify what portion of the worksheet you wish to access when you open an Excel file.
Named Range
Use this drop-down list to specify Entire Worksheet or Other. When you choose Other, the Other Range dialog box displays, which allows you to specify a cell range.
Current Value
This is the current cell range value of your worksheet.
Use row above selected range for column titles
Choose this option when you want to use the row above the selected range for column titles.