Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 to 2007 , ActiveWorkbook.ReadOnly | Excel Programming | |||
PivotCaches.add Difficulties | Excel Programming | |||
ActiveWorkbook.SaveAs in excel 2007 | Excel Programming | |||
Pivotcaches add method | Excel Programming | |||
PivotCaches.Add | Excel Programming |