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

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
>