I have an excel file that has numerous data connections to a database. How can easily edit the connection string to change the file name of the copied database? I need multiple sets of excel and access files to accommodate multiple users.
Excel Template - Database
Excel Template 2 - Database 2
Excel Template 3 - Database 3
I was hoping for find and replace or a manage external links window.
Excel Template - Database
Excel Template 2 - Database 2
Excel Template 3 - Database 3
I was hoping for find and replace or a manage external links window.