Anyone using a web service as a data source in Excel 2007?
Posted
by Scott
on Stack Overflow
See other posts from Stack Overflow
or by Scott
Published on 2010-03-16T15:08:17Z
Indexed on
2010/03/16
15:11 UTC
Read the original article
Hit count: 190
excel
|web-services
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.
© Stack Overflow or respective owner