Application defined or object defined error when creating a Pivot Table

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