Importing Excel Spreadsheet

  • Thread starter Thread starter Red
  • Start date Start date
R

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.
 
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.
 
Back
Top