Last week while i was trying to edit an Excel form based application to modify the connection string information , I felt like I was at a dead end for a few hours.  I was trying to edit the connection string to point the application to a different SQL Server. The Excel form application had that DSN based information hardcoded in it.

Spending a few valuable minutes talking to an Excel Expert , I learnt that in Excel 2003 form based application , there is no direct way to edit the Database Connection related information. Thank you "Addins" , there's one such addin available which can make life easier when working with those old excel 2003 files.

You can download the addin( ModifyQryPvtTbl.xla  ) that i've attached  in this post , hopefully this should save the trouble for all those Excel 2003 editors out there :)

Happy working !