Change Database Links In Excel Workbooks

Do you have Excel97 workbooks with queries and/or pivot tables linked to Access97 databases?

If you need to point the queries/pivot tables at a different database, you have moved the original database, or you have moved the workbook, you will need to change the embedded links.

To perform the task easily, please visit our site at and download the free Visual Basic utility.

The routine uses DSN-less connections. It will replace DSN connections with DSN-less connections, and change existing DSN-less connections to point to a new selected location.



Influential Computers is a family run IT Consultancy, situated on the Oxfordshire Berkshire border near Reading, England.

Page updated 03/08/2014 20:42:09
    Copyright © 1999-2021 Influential Computers All Rights Reserved