error in creating pivot table in C#

[ajz]

Hi,
I am trying to create a pivot table in C# using method provided by Microsoft "CreatePivotTable" http://msdn.microsoft.com/enus/libra...ffice.12).aspx

In that method, 4th parameter is version number. If I give XlPivotTableVersionList.XlpivotTableVersion10, pivot table gets created successfully.
but, If I use XlPivotTableVersionList.XlpivotTableVersion12, method is throwing exception of "invalid argument"
I am using Excel 2007.
please, help me out...
Do I need to do some additional settings to use for Version12



Thanks,

[OnErrorGoto0]

What formatis the workbook in and which PIA do you have referenced?

[ajz]

Thanks for your quick answer..
I have referenced Office12 PIA. Everything is referred with respect to Office 12 only..


Thanks,