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?

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"Frank" wrote:

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?

Thank you! That worked very well.

"Jan Karel Pieterse" wrote:

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

.