In excel create a connection to another excel workbook
Posted on 2013-05-22
I have a spreadsheet that gets some data from another excel workbook. It works fine, except if there are new, additional columns in the source workbook, they are ignored, don't show up in spreadsheet using the connection. It seems like the connection is somehow remembering all the column names and will only import those, even though the sql is like select * from ....
If there are fewer columns in the source workbook, then the missing columns (headers) will show up like Column1, Column2, etc, but, of course, no data in these columns.
Any ideas on how to make the table expand / shrink with the source?
excel 2010, 32 bit, on a windows 7 64 bit box.
connection looks like (points to a sharepoint folder):
Command type: SQL
Command text like:
FROM `\\network\DavWWWRoot\SiteDirectory\path\VWProductSpendData.xlsx`.qryVWProductSpend qryVWProductSpend
connection was create from within excel using "From Other Sources", selecting Excel Files*