Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating A Datasource
I have an Excel spreadsheet that is linked to an Access database. The
location of the database has chnaged. When I open Microsoft Query, how do I change the location? Or if I need to change the *.dqy file, how do I change it so that it referrences the new location without having to re-do the entire Excel file (thich includes a pivot table and chart). Unfortunately it's been 3 years since I created it, and am a little rusty. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disconnecting a Pivottable from its Datasource | Excel Discussion (Misc queries) | |||
Changing datasource for pivottables | Excel Discussion (Misc queries) | |||
Datasource for pivot tables | Excel Discussion (Misc queries) | |||
Add buttons in a form from a datasource | Excel Discussion (Misc queries) | |||
Change pivottable datasource | Excel Discussion (Misc queries) |