ActiveWorkbook.PivotCaches.Create in Excel 2007

J

Joe

Hello,

We just upgraded to 2007 from 2003 and now my pivot tables don't get create.
I get an error: Type mismatch when calling Create.

Set pivotDataRange = dataSheet.UsedRange
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
SourceData:=pivotDataRange)

Is there a change that no longer allows a range to be set as the SourceData?

Thanks,
Joe
 
Top