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.

If you are in Excel, can't you simply goto:

Data | Pivot Tables.

Click the "get external data" toggle and then follow the prompts to browse
for your file?

Roger

"CLASSC" wrote:

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.

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.

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.

I'm glad Pivot Play helped.....thanks so much for the feedback.

***********
Regards,
Ron

XL2003, WinXP


"CLASSC" wrote:

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.