ActiveWorkbook.PivotCaches.Create in Excel 2007
 

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:=xlDa tabase,
SourceData:=pivotDataRange)

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

Thanks,
Joe