I am trying to place a Query Load at a specific Column and Row in my workbook. However, when the query loads the data to the worksheet, it adds extra columns to the created ListObject Table, depending upon the number of columns that were offset From Column A.
1] If i Load the Query data to Cell B5, the Table adds 1 extra Column at the end.
2] If i Load the Query data to Cell D5, the Table adds 3 extra Columns at the end.
3] Also the Table always gets highlighted (Selected) whether loaded "Manually" OR via "VBA Code".
I am not sure if this is the default Query load behavior or a Problem with the Query itself. It would be nice if someone could review the attached sample workbook, Query and csv files and assess where the problem lies?
BTW, i am using Excel 2016 Pro 64 bit version and to be sure it is not an Excel issue, i just reset (repaired) my Excel to the default condition.
Here is a screenshot:
Here are the files:
Hope someone has an idea and possible solution to remedy this issue.