I'm pulling in data from SQL via a query connection in Excel 2007, but when the data is pulled in it disrupts the headers [adds blank columns] when I am pulling the data in underneeth [row13].
In Excel 2003 the External data connection could be controlled to not change column formatting but I can't find this in 2007?
In Excel 2003 the External data connection could be controlled to not change column formatting but I can't find this in 2007?