Anyone using a web service as a data source in Excel 2007?
- by Scott
Can I use a web service as a data soruce for Excel pivot tables?
Currently, the soure data for the pivot table is being exported from the DB to a CSV file. Then the CSV file is loaded into a worksheet in the workbook. From there, a pivot table is created in the same workbook. We are looking to streamline this process. The SQL db and pivot tables are the constants.
The pivot tables are generated dynamically from a public-facing website. This is not an internal app so the preference is to not connect directly to the DB.