I have several workbooks which all contain numerous ODBC connections pulling in separate tables of data. The connections are all sets of similar sql queries which only differ by minor parameters. They function just fine, but after I save and close the workbooks, upon reopening to refresh the connections, I find that handfuls of them disappear. I have some connections established between an external database, and others connected to external workbooks, but the disappearances happen in either case.

My method for establishing the connection is to:
1. Add Connection
2. Select/Open Connection
3. Select Table
4. Open Connection Properties
5. Select definition tab
6. Input SQL code to command text box
7. Select OK

Is this a common problem? Should I be establishing connections through a different method?