title: Anyone using a web service as a data source in Excel 2007?
body: <p>Can I use a web service as a data source for creating Excel pivot tables?</p>
  
  <p>Currently, the soure data for the pivot table is being exported from our SQL db to a CSV file. Then, the CSV file is loaded into a worksheet. From there, a pivot table is created in the same workbook. 
  Customers login to a website, click some links, and an excel file (with data and pivot table) is generated. This is a public app so the preference is to not connect directly to the DB.</p>
  
  <p>We control the database and generate the output. We are looking to streamline this process. The SQL db and pivot tables can not / will not change.</p>