How can I remove an invalid path for an Access file from a pivot

C

CLASSC

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.
 
R

Roger Converse

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
 
R

Ron Coderre

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)
 
C

CLASSC

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!
 
R

Ron Coderre

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

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

XL2003, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Pivot Data Range formula reference problem 0
Pivot table report invalid 0
Using 'indirect' function with full network path 0
Using 'indirect' function with full network path 0
Using 'indirect' function with full network path 0
Links to Excel Workbooks change 0
XL2007 Pivot Charts: Path to data in another workbook keeps chang 3
Data source has changed - can't save the new path. 3

Top