View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug N Doug N is offline
external usenet poster
 
Posts: 1
Default Connect Pivot Table to WSDL web service source?

Is it possible to create a pivot table directly (or relatively directly)
from a Web Service? I've looked around, but can't find where I can point
Excel at a WSDL.

I know I could use the web service add-in to retrieve the data and dump it
into a tab in Excel, then make a pivot off of that data. But I have 65K
rows of data, in this case, and so a direct pivot table service to a web
service is really what I need.

Thanks in advance for any tips.