what i have discovered is that owc9 dont support recordsets while owc11
support recordsets

' owc9
objPivotTable.DataSource =objRS

'this give error : Class does not support Automation or does not support
expected interface
But above line of code works fine if owc11 is used.

it means OWC11 is capable of accepting Recordsets as datasource whil owc9 is
not.

while following code doesnt work for any of owc9 and owc11


objPivotTable.DataSource =objDataSet '' doesnt work for b


so i think next version of owc can be made capable of accepeting Datasets as
datasource as well.