Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set data source dinamically
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set data source dinamically
See if the Pivot Play add-in at this website helps:
http://www.contextures.com/xlPivotPlay01.html Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Nikolajus" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel set data source dinamically | Excel Programming | |||
renaming sheets dinamically | Excel Programming | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Saving a position dinamically | Excel Worksheet Functions | |||
Create Tables dinamically | Excel Programming |