I can't use a named range when I try to import a range from an Excel workbook.

You can use a named range when you import a workbook that was saved in the Microsoft Excel 5.0/95 format; however, you must use a cell range when you import a workbook that was saved in an Excel 97 or later format.