I keep running into this error when I try to create a pivot table.
The debugger highlights the following line:
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"SCR!A1:AJ65000").CreatePivotTable TableDestination:="[" & wbtemp.Name & "]Statistics!R64C2", _
TableName:="PivotTable6", DefaultVersion:=xlPivotTableVersion10
I noticed that when I delete the old pivot table that its supposed to replace, it will work, but otherwise it gives me the error.
The strange thing is that I don't seem to get this error the other places that I've done this. Replacing the old pivot table. I can't just make it update the table because sometimes, the table doesn't exist yet, which is why I create one.
Please let me know what the problem could be.
Thanks
Bookmarks