See if the Pivot Play addin at Debra Dalgleish's website handles your
situation:
http://www.contextures.com/xlPivotPlay01.html

Post back with any questions.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"maryj" wrote:

Client inherited some files with pivot tables that are pulling data from an
Access database. The access database was moved to a different drive so when
she tries to refresh the database, she gets an error that the file can not be
found. We have tried to redirect it to the correct location by browsing and
selecting the file but we then get a dialog box asking for the administrator
password. If we leave the pasword field blank, we then get a message that
query can not be edited with MS Query. She is able to open the database and
is not prompted for any passwords. How can we redirect the pivot table to the
new location of the database?
--
maryj