I was wondering if I could populate a Data Control from my ASP script then populate the Pivot Table from the Data Control. I am using Office Web Component 2000 (pivot table 9.0) and SQL server 2000. I should also ask if anyone out there has used the pivot table activeX in their web applications ? I seem to be facing a new issue everyday with this thing. My primary challenge is to make as secure a connection as possible and get this thing to work reliably over the web. <BR>Any sample code would be welcome! <BR>