Hello,
Every time I try to create a pivot table, based on either a query or a table, I get the error message "Problem obtaining data -- from Excel".

I have tried creating artificially simple queries and new simple tables (in different database files), but always the same message. I have created Pivot Tables in the past on similar queries without this problem.

The only thing that i could find on the Microsoft Knowledgebase that was similar related to queries with parameters. So, it didn't apply here.

Thanks,
Ken