Pivot Table path to Access

[Perry V.]

The pivot table wizard "Get Data" is not allowing me to
change the source path to an Access Database. I want to
move the Access source file from one folder to another,
however when trying to point the pivot table to the new
path I get an error of "This query cannot be edited by
the query wizard".

Suggestions?

 

[Tushar Mehta]

Proceeding beyond the warning message, is there access to the actual
SQL? From what I remember, the answer is yes -- but I can't test it
right now. From the SQL fix the path specification; it is quite self-
evident. Once done, the GUI will become usable.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions