Okay... I'm selecting a data range which I've already named in the source workbook, upon importing the data into the cell I choose the data comes in as a table with headers.

The problem is two-fold:

1. I only need the range of data to import (NOT AS A TABLE)
2. upon importing, it comes in as a table that I have to manually go in and convert to a range.

Is there a method to avoiding this or is this just one of those things that you have to manually do?