troubleshooting Question

manage multiple data connections in a workbook

Avatar of ktjamms2
ktjamms2Flag for United States of America asked on
Microsoft ExcelMicrosoft Applications
23 Comments3 Solutions331 ViewsLast Modified:
I created a workbook with several tabs that connect to an Access database with several different queries. Each tab is connected to a different query within the same database. I would like to be able to use this workbook as a template, but every six months, the database will change it's location. It will be the same querries on the same tables with the same names, just a different location for the database (every six months the old database is put to archive and a copy is made in a new folder for going forward). I want to reuse my workbook but would like it if I didn't have to go through 30+ tabs and change the datasources. Does anyone have any suggestions how to easily change/manage the data source connections?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 23 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros