New DB Query - Relative Path

  • Thread starter Thread starter kaiser
  • Start date Start date
K

kaiser

Does anyone know of an easy way to manage the relative path link to a
external database for excel? I have a spreadsheet where I've importe
about 50 Access DB Queries. My problem is that if I copy the Access D
into a different folder or network folder the "link" is broken as Exce
cannot locate the DB any longer. I know that I can individuall
recreate these 50 DB Queries but this is a hassle. I'm sure there'
got to be a way internally to Excel that I can access to easily chang
this relative path.

Thanks
 
If it is only one file you can easily use Edit/Links and update the source
file.

HTH

PC
 
Back
Top