XL Connect Updates

2 things I am looking for that I have not been able to find information elsewhere.

1- Does anyone have information or instructions on how to update the connection information for XL Connect from an old version to a new version within a spreadsheet?

2- Does anyone have any information or instructions on any tool or method to bulk update all XLConnect related sheets and templates?

This would be for someone going from 9.05 to 10.1.