Excel 2007- SQL table - How to protect connection details?
I've been disrtibuting my reports in MS-Excel (2000/2003) which are refreshed from SQL Server data. For connecting SQL Server a File DSN is used and the password is saved in Connection properties. The login details are not visible to the user.
But, in MS-Excel 2007 user can see the 'Definition', Connection String details and many more...
I want to hide the connection string details from the user, is it possble?