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

Posted on 2009-04-23
Last Modified: 2012-08-13
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,
Question by:nbp2004
    LVL 12

    Expert Comment

    by:Gary Dewrell
    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.
    LVL 15

    Accepted Solution

    As I see it you have two options:
    1: Set up the users you need at server side. (SQL users or eventually with Active Directory groups) and remove the password from the connection.
    2: Remove the connection before distribution. It will require a setup where you will need to distribute the report each time fresh data is available but you can control what you have out there.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now