Occasionally, i will create an excel spreadsheet that links to access data tables and i need to move these from my folder to a co-workers. Is there a way to update all of my links to the db at once rather than editing each individual table link?

Also, if i change the name of my linked database is there a way to have excel recognize that automatically?