title: What do I need to do to make Excel access a Web Query via HTTPS?
body: <p>I'm trying to implement a page that allows Excel users to use the data it provides via the Web Query feature provided by Excel.</p>
  
  <p>It's all working out pretty nicely, as long as I use HTTP (even BASIC user authentication works).</p>
  
  <p>As soon as I switch that over to HTTPS Excel won't download the data anymore (it's even a fully official SSL certificate, so it's not a problem with a self-signed one).</p>
  
  <p><a href="http://support.microsoft.com/kb/290347/EN-US/" rel="nofollow noreferrer">This Microsoft knowledge base article</a> pretty much describes the problem.</p>
  
  <p>Now the part that makes me wonder is this:</p>
  
  <blockquote>
    <p>This issue occurs when Excel cannot initiate a connection because of the settings on the secure Web server.</p>
  </blockquote>
  
  <p>This seems to imply that there is <em>some</em> way to get this working, but there's not even a hint at the direction I need to look at.</p>
  
  <p>Should the "because of the settings on the secure Web server" be taken at face value, or is it just a Microsoft way of saying "this won't work unless you buy the right software from us"?</p>