How to change Pivot table data source?

J

Julie

Good day everybody,

I have a pivot table in SALES.XLS with data source from DATA.DBF in my local
C:\drive where I refresh pivot data in SALES.XLS after I updated the DATA.DBF
every month. Then I copy the SALES.XLS into server for my report user to use.
I have a report user who have made a copy of SALES.XLS and customised the
pivot table. He want to be able to refresh his version of SALES.XLS every
month. So my solution is to copy DATA.DBF into the server for him to refresh
data.

My question is how do I change the data source of the pivot table from
C:\DATA.DBF to F:\DATA.DBF?
I have used the BACK button, but it take me until selecting Table and Field
but not the Select Directory screen.
My not so efficient solutions are : Asking my user to create a new pivot
table or copy DATA.DBF to his C:\drive.

I hope some one can tell me how to change the directory of Pivot data.

Thank you in advance and have a nice day.

Best regards,
Julie
 

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

Pivot table data source 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data Aggregation 0
Pivot table report invalid 0
DATE Calculations in pivot table 0
Multiple Tables and Multiple Pivot Tables Help 0
Changing Pivot Table Value Field Labels with VBA 0

Top