I have a workbook from a previous company that has pivottables based on an
odbc-compliant external data file. But when I try to refresh the pivottable,
I get this error:

[Microsoft][ODBC Driver Manager] data source name not found and no default
driver specified

Does anyone know how to determine what the data source "name" is so that I
can recreate it?

Mike,

Nothing to do with your question I am afraid, but I was hoping to talk to
you about a post of yours last April.

Could you drop me a line at

bob dot phillips at freeuk dot com

Thanks