Prev: Pull data (sumif?) from an external workbook
Next: appXL = CreateObject("Excel.Application")
From: Joe on 18 Mar 2010 09:01
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


 | 
Pages: 1
Prev: Pull data (sumif?) from an external workbook
Next: appXL = CreateObject("Excel.Application")