Changing Data Links

[Frank]

I have several Excel files that use External Data Links to an Access
Database. The location of the Access Database has been changed to a new
folder. Is there a way in Excel to change the link location (address)
without having to delete and rebuild the links? Somplace where I can type in
the new location for the source data?

 

[Jan Karel Pieterse]

Hi Frank,

The location of the Access Database has been changed to a new
folder. Is there a way in Excel to change the link location (address)
without having to delete and rebuild the links? Somplace where I can type in
the new location for the source data?

Try my query manager addin:

www.jkp-ads.com/download.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Luke M]

I would think you can do it from either the Data - Edit Query menu, or Edit -
Links menu.

 

[Frank]

Thank you! That worked very well.

Hi Frank,


Try my query manager addin:

www.jkp-ads.com/download.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

.