Q: Change pivot table source path?
 

All,

I've inherited an Excel 2003 pivot table report from a coworker who has left
the department. The pivot table reads from an Access database that was
located on his local computer.

I've moved the database to our server, but do not know how to refresh the
pivot table to change the path of the mdb (the name of the mdb and the
queries within it are the same, only the folder has changed).

How do I go about doing that? I don't want to redo the whole pivot table
unless I have to.

Thanks!
-Mark

Q: Change pivot table source path?
 

found the solution.

For those interested:
http://www.mcse.ms/archive124-2005-8-1637938.html

-Mark




"Mark" wrote:

All,

I've inherited an Excel 2003 pivot table report from a coworker who has left
the department. The pivot table reads from an Access database that was
located on his local computer.

I've moved the database to our server, but do not know how to refresh the
pivot table to change the path of the mdb (the name of the mdb and the
queries within it are the same, only the folder has changed).

How do I go about doing that? I don't want to redo the whole pivot table
unless I have to.

Thanks!
-Mark