If you look at the excel VBA help on the CreatePivotTable method of the
PivotCache Object, there is a code sample that shows how to create a pivot
table using ADO and in the example it uses OLEDB.

--
Regards,
Tom Ogilvy


"Sven Peeters" wrote:

Hi,

We would like to avoid the use of ODBC when linking a datasource to a
pivottable.
It theer any way to use OLEDB instead of ODBC for pivot-tables?

Regards,

Sven Peeters