Thanks soooo much!

I used the free Pivot Play and it worked great! I was so frustrated because
I had 5 pivot tables I did not want to re-create and the Get Data option did
not work!
"Ron Coderre" wrote:

The free Pivot Play add-in, located at Debra Dalgleish's website, may help:
http://www.contextures.com/xlPivotPlay01.html

One of it's main functions is to change the data source location of Pivot
Tables that use external data pulls.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"CLASSC" wrote in message
...
I have an excel pivot table that uses Access as the data source, the file
is
on the network drive "m" at work. Does anyone know how to change the path
of
the Access file? The Access file is now on my C drive at home and it
won't
let me change the path.