Connect Pivot Table to WSDL web service source?

D

Doug N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Doughnut Chart linked with the slicer in the pivot table 0
Changing pivot table ADO recordset 0
Excel VBA as a web service 0
How to Submit rows of a repeating table to a SharePoint list 1
How I can set dynamic pivot table ONLY when I have enough data point 1

Top