<div>
nbp I do not beleive this is possible. Hopefully someone smarter than me will come along and prove me wrong but I do not believe the functionality exist in excel 2007 to do what you are aksing.<br />
<br />
Wish I had a better answer for you.
</div>


nbp I do not beleive this is possible. Hopefully someone smarter than me will come along and prove me wrong but I do not believe the functionality exist in excel 2007 to do what you are aksing.

Wish I had a better answer for you.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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.<br />
But, in MS-Excel 2007 user can see the 'Definition', Connection String details and many more...<br />
I want to hide the connection string details from the user, is it possble?<br />
<br />
Thanks in advance,<br />
nbp
</div>
</div>


Hi Experts,

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?

Thanks in advance,
nbp

Excel 2007- SQL table - How to protect connection details?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.