Newbee Question about excel imports

3.95K viewsDataLink
0

I am in the first day of my trial period. So bear with me.
Importing data from Excel is crucial. Deal breaker.
So I named my ranges in Excel. I went to data link and chose the file and click next. Right after I go though that password thingy, I am in a position to chose columns but nowhere does it give me the option of choosing the named range.

Where do I enter the name of the range that I wish to chose?

0

Worked just fine. Thanks.

Just a quick followup. Is there a way other than double clicking column by column to select the columns. I regularly get massive data sheets.

You are viewing 1 out of 4 answers, click here to view all answers.