Re-direct ALL Data Connections - Excel 2007
I have an Excel 2007 workbook with 12 different data connections. Each
connection is pointing to a different Access query within the same Access
database. If I move the database to a different folder, is there a way to
re-direct all the links to the new file path for the database? Currently I'm
having to change each connection one by one. This seems silly, since their
all pointing to the same database.
Jeff
|