Pivot Table path to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Perry V. - 16 Dec 2003 15:15 GMT

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?

Reply to this Message

Tushar Mehta - 16 Dec 2003 15:50 GMT

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.

Signature

Regards,

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

> The pivot table wizard "Get Data" is not allowing me to
> change the source path to an Access Database. I want to
[quoted text clipped - 4 lines]
>
> Suggestions?

Reply to this Message