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.