Setting up external query without having Header Rows displayed in Excel 2007
Posted on 2010-08-20
In Excel 2003, when using Microsoft Query to setup queries to external data sources (such as another file, you had the option of "not including header rows". In Excel 2007 I can't seem to find out how you do that? It doesn't appear to be available under the "Properties" option on the Import Data. I see that you have optoins on how you want to view the data such as Table, PivotTable, PviotChart and PivotTable and "Only Create Connection". I might expect that "Only Create Connection" might give me this option, but when setting you a new connection to an Excel file, and after leaving Microsoft Query, it is "greyed" out so I can't select it.