Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table error
I have the following codes. It works fine the first time I run it. The next
time I run it there is a error message "Method create pivot table of object pivotcache failed". It will only work fine if I exit Excel and run the codes again. Anyone knows why there is a error. The code stops at the "Set PT" row. FYI, I set PTCache and PT to nothing before I exit the codes. Set PTCache = Workbooks("Template.xls").PivotCaches.Add(SourceTy pe:=xlDatabase, _ SourceData:=Range("A1").CurrentRegion.Address) Set PT = PTCache.CreatePivotTable(TableDestination:="", TableName:="PivotTable1") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table #VALUE! Error ! | Excel Discussion (Misc queries) | |||
XML error in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Discussion (Misc queries) | |||
Pivot Table error (424) | Excel Programming |