Setting data source programmatically for Pivot table

Question

Hi,
   Does anyone know if a worksheet has a Pivot table, how can I set it data source programmatically via VSTO?  Is there any sample code?


Watcher

Answer 1

Hi,
   Can anyone help?  What I mean is that if I have a Pivot table, how do I, using VSTO, bind the data to the pivot table?

Watcher

Answer 2

VSTO doesn't have databindable pivot table control. So you will need to use the Excel object model to manipulate the pivot table.

Paul Stubbs
Program Manager