I have some spreadsheets for 2009 and for 2010 that have been created on Excel 2003 that have a connection to another spreadsheet for the source data.
I am now copying these over to create the new files for the calendar year 2011. The connection to the 2010 data stay intact. In the past, I was just able to revise the "connection string" in the properties/definitions of the connection to reflect the new location of the current source data.
This does not seem to work for 2007, so I removed the existing connection and created a new one to the new location, but when I refresh/import, I only get the 1st column of the data, not all 10 columns that are on the source spreadsheet.
Any ideas?
I am now copying these over to create the new files for the calendar year 2011. The connection to the 2010 data stay intact. In the past, I was just able to revise the "connection string" in the properties/definitions of the connection to reflect the new location of the current source data.
This does not seem to work for 2007, so I removed the existing connection and created a new one to the new location, but when I refresh/import, I only get the 1st column of the data, not all 10 columns that are on the source spreadsheet.
Any ideas?
