ODBC Issue with Pivot Table

[Mike H.]

I have a workbook from a previous company that has pivottables based on
external odbc-compliant files. The odbc driver returns this error:

Error received when refreshing pivottable: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified

Obviously, I need to set up the same source names, but how do I determine
what they were?

 

[Shane Devenshire]

Hi,

I'm not sure about that error message and I'm not sure that all ODBC
database handle this the same way, but

Click in the pivot table and then choose PivotTable, Pivot Table Wizard,
Back, Get Data, Next, Next, Next, and select the option View data or edit
query in Microsoft Query.
Click Finish, then click the SQL button.

This will show you where the PT's are trying to get their data from. You
can recreate the query from MS Query. Or you can modify the SQL statement.
Or once you get the idea, you can create the pivot tables from scratch - that
would be my choice.

Its hard to immagine a pivot table from one company working with data from
an entirely different company. You might think that it would save time to
just convert the pivot table to the different data sourse but that is
probably not going to be the case.