Newbee Question about excel imports

3.94K 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

Hi – thanks for posting.

The Excel model needs to be saved and closed prior to connecting to it via Quantrix DataLink. If it is left open there is some conflict that prevents Quantrix from seeing the named ranges.

Hope this helps!

-Mike

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.

0

Glad that helped. If you double-click the named range itself that will grab all the columns in the data source.

0

Thanks again. Back to the exercise.