set data source dinamically

T

tezta

Joined
Oct 12, 2007
Messages
1
Reaction score
0
[font=Verdana, Arial, Helvetica]Hello,

I am using MS Office 2000.

I've got a pivot table. Data source is a MS Access table through MS Query.
Both report with pivot .xls and data source .mdb are in the same folder. When I move my .mdb and .xls files to another folder, Excel pivot cannot
refresh data automatically because .mdb is not found. All I need is to set up
data source manually. Is it possible to do this automatically, assuming that
both .mdb and .xls will always be in the same folder together?

Thanks in advance,
Nikolajus[/font]
 

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

set data source dinamically 1
Changing PivotTable Source programmatically 1
Please help! Cannot open pivotTable source file.... 2
Pivot table - How To Obtain a External data Source?? 2
How to build / refresh pivot table without ODBC?? 1
How to identify Chart Source data as range? 3
Automatically Refresh pivot table 6
How do I update a ODBC query in Excel using pivotTables in VBA? 6

Top