Can i see the code i use ODBC via VBA every day many times a day this should not happen??
Excel ODBC is ripping from what ?? crystal (should self contain) or some bespoke system
ill look at the code if you like,,,
5 mins ODBC is not long for 5 sheets so code and links is good...
theres little secret in VBA codes so should be ok to post ... un less passwords but once signed in to ODBC should stay in an no PW reqd... again that session, untill you log off the network that is..