Importing Excel Spreadsheet

[Red]

I'm trying to import an excel spreadsheet with a named range of [All_Data]
but when working though the import wizard it doesn't recognise any ranges
only the worksheets.

The [All_Data] range is defined as
OFFSET(CombinedData!$A$1,0,0,COUNTA(CombinedData!$A:$A),10)

Thanks for all help.

 

[John Nurick]

Hi Red,

It only works with "real" names (e.g. "Sheet1!$A$1:$G$99"), not with
names that contain formulas.

I'm trying to import an excel spreadsheet with a named range of [All_Data]
but when working though the import wizard it doesn't recognise any ranges
only the worksheets.

The [All_Data] range is defined as
OFFSET(CombinedData!$A$1,0,0,COUNTA(CombinedData!$A:$A),10)

Thanks for all help.