I have a large number of 2003 Excel Pivot Tables that connect via odbc to
2003 Access queries. I recently converted one database to 2007. I then
converted one Excel file that looks at that db to 2007. I went into the new
2007 file and set up a new Connection to look to the new 2007 Access query.
That done, I went into the first pivot table and selected the new connection
- Pivot Table Tools, Change Data Source, Use An External Datasourse, Choose
Connection button. And now I'm presented with this long list of connections.
I went into the properties and made sure I selected the connection that was
the new one to the 2007 database (.accdb). The said Open which brings back
the Change Pivot Table Data Source window with that connection listed, then
ok. I get an error "You cannot choose a connection file that is incompatible
with the existing connection." So how else besides rebuilding every single
pivot table (if I do a new pivot table it lets me select that connection) can
I change the data source? I thought this new Connection setup in 2007 was
supposed to be easier and allow for this type of change. What am I doing
wrong. The help files don't cover enough when it comes to converting and
changing the data sources. This has stopped my work and I'm not rebuilding
all my reporting files. Help! Linda