| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTables linked to Access Database
Hi there
I have a workbook with PivotTables retrieving summary data directly from Access Databases. Can anybody tell me: Firstly - How do I determine the folder/ location of the .mdb file that the data is being read from. Secondly - How do I change the PivotTable to read the data from a different folder / location or a different mdb file if the database is renamed. Any help appreciated. Thanks Hilton |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| PivotTables: Restricting access to Report Filter Pages sheet data | Excel Discussion (Misc queries) | |||
| Refreshing a linked Access Database | Excel Discussion (Misc queries) | |||
| How can i create a form linked to a database | Excel Discussion (Misc queries) | |||
| Searching a linked database | Excel Discussion (Misc queries) | |||
Linear Mode
