Hello, I created an xll to make some tasks on an Oracle database (select, insert, update...). Everything works fine. Now, what I would need is creating a pivot table in an Excel worksheet directly without importing data into a worksheet. I created a name using the command xlcDefineName. This name contains the result from a query. Then I created a pivot table using xlcPivotTableWizard but it tells me the reference is not valid. I found two workarounds: - creating a hidden worksheet in order to store the needed data: problem where there are more than 65k lines - using VB: need to recode everything and it will be slower Any other solution using only the xll? I am not in Excel 2007 so I cannot use all the new features. Thanks Nico
