We have several Excel spreadsheets with links to Access Databases. He have move the databases & need to change the links to the new location. But, I can't find where to do this. I looked under "Edit" and see "Links" there, but it is greyed-out and not available to me. How can I re-map the links. Thank you.
The "links" are probably actually QueryTables (ie the result of Data > Import External Data > New Database Query ) To change the location of the source file you would need to change the Connection property of the QueryTable (and possibly also its SQL or Command property). If you need to change multiple workbooks I can offer you a free LinkManager utility that will do it for you. Email me at Bill_Manville at compuserve dot com to request a copy. Bill Manville MVP - Microsoft Excel, Oxford, England
Thank you, I appreciate your help "Bill Manville" wrote: > The "links" are probably actually QueryTables (ie the result of > Data > Import External Data > New Database Query ) > > To change the location of the source file you would need to change the > Connection property of the QueryTable (and possibly also its SQL or > Command property). > > If you need to change multiple workbooks I can offer you a free > LinkManager utility that will do it for you. > > Email me at Bill_Manville at compuserve dot com to request a copy. > > Bill Manville > MVP - Microsoft Excel, Oxford, England > >
