title: Refreshing Web Query in Excel Services
body: <p>I have an excel file that uses a web query to pull in data. I can view it and refresh it fine locally in Excel 2010.</p>
  
  <p>I upload it to SharePoint 2010 and can view the data in the spreadsheet in the browser using Excel Services. However, when I click to refresh the data in the spreadsheet in the browser (clicking Data > Refresh All), the data does not get refreshed. One thing to note is that when I do open up the excel spreadsheet in the browser it shows this message:</p>
  
  <p><img src="https://i.stack.imgur.com/Rmg6X.png" alt="enter image description here"></p>
  
  <p>You can see it mentions "Web Queries". It also mentions "external data queries" can only be refreshed in the client version. I can refresh ODC file connections to sql server just fine in Excel Services, aren't those "external data queries"?</p>
  
  <p>I guess the basic question is this...</p>
  
  <p><strong>Can you refresh a web query in Excel Services, if so, then how... if not... do you have a supporting link explaining why? (because I'm having a heck of a time finding one)</strong></p>
  
  <p>Thanks in advance.</p>