This may be a bit off topic. If so, slap gently and I'll go away...
Anyway, I'm looking for a non-programing way to allow our end-users to migrate their Excel spreadsheets with embedded queries from our test MS SQL Servers to production servers. Excel seems to embed significant amounts of server information from whatever dsn is used within the sheet itself. I hope that there is a way to make a logical server association with easily manipulated physical attributes. I also hope that one of the clever members of this board have solved the problem.
Any help is appreciated.