I woulld like to use excel to connect to SQL and pull data in. What I would like to know is how can I put the connection string in an excel add in? I want it hidden. If that not the way to do it. what is the correct way? Keep in mind the excel spread sheet should have the ability to update the data via a refresh button and again the connection string is never exposed.