title: Excel 2007 Pass-Through Windows Authentication
body: <p>I've created a simple (asmx) web service which returns a DataSet.
  I've added the webservice to my Excel 2007 workbook using the Data -> From Web button and I'm able to view / refresh the data.</p>
  
  <p>The problem comes when I need to secure the web service:  I've turned on Windows authentication for the web service and the request uses SSL.</p>
  
  <p>Unfortunately, the user's logged on windows credentials aren't used by Excel when trying to refresh the data - the refresh fails.</p>
  
  <p>If I click on Data -> Connections -> Properties -> Definition -> Edit Query, only then am I prompted for my windows credentials and does the refresh then succeed.... not a problem for me, but not something I want every user of this spreadsheet to have to do... any ideas how to make the prompt come up when the refresh is attempted instead of having it fail??</p>
  
  <p>Thanks!!</p>
  
  <p><strong>Update</strong> Answers so far are to do with SharePoint and Excel Services  (neither of which are any use to me)... and one link for which "The following procedure does not apply to data that is retrieved from a text file <strong><em>or a Web query</em></strong>"... I just want a person with a copy of excel on his desktop machine to be able to update from a password-protected web service... is that so hard Microsoft??</p>
  
  <p><strong>Another Update</strong> Still no answers accepted - because no answers so far have provided a working solution  ( Nice googling though - thanks guys ;-) )</p>