I have a number of Excel templates that are linked to external databases.
Sometimes I need to adapt the database for specific reporting needs -- when I
do this I want to retain the old database for other reasons, but would like
to make a copy of the database and have the excel template I am working on
point to the new database instead of the old database. I know I can move the
database's location and then I can re-assign the database, but is there a way
to re-link Excel to the database without having to change the location of the
database I am linked to?