Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel set data source dinamically
Hello,
I am using MS Office 2000. So, i've got pivot table. Data source is MS Access table through MS Quoery. 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 ..mdb and .xls will always be in the same folder. Thanks in advance, Nikolajus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Dinamically reference Acrobat Distiller? | Excel Programming | |||
Create Tables dinamically | Excel Programming |