title: Mac Excel web query not working
body: <p>We use <code>web queries</code> to retrieve data in Excel for reporting purpose. These Web queries are working correctly in Excel 2007, 2010, 2013 and 2016.<br>
  But when used in <strong>Mac Excel 2016 it fails</strong>.</p>
  
  <p>We perform these web queries using <code>VBA</code> and retrieve data generated by a <code>Spring REST</code> interface.</p>
  
  <p>I already tried using <code>http GET</code> instead of <code>http POST</code> and tried performing the web query via the UI ('Data' -> 'Get External Data' -> 'Run  Saved Query' using a <code>.iqy</code> file).<br>
  Also error seems not to be content related <em>(tried very simple html; <code>&lt;html&gt;&lt;body&gt;&lt;table&gt;&lt;tr&gt;&lt;td&gt;col1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;value1&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/body&gt;&lt;/html&gt;</code>)</em>.</p>
  
  <p>When using Wireshark to analyze the traffic, the response of the REST call is correct (<code>http 200</code> with correct content).</p>
  
  <p>Errors reported using UI import using '.iqy' file: <code>"cannot locate the internet server or proxy server"</code>.
  Error performing web query using VBA: <code>"Error 1004 Application-defined or Object-defined error"</code>.</p>
  
  <p>Does anyone have an idea what can cause this behavior?</p>