hello,

Extract from the Code. This gives me the error msg mentioned in the subject line. can i get some help on this please?. I clear the sheet (Scores) completely before running this code

    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
        "FilterData!A:AH", Version:=xlPivotTableVersion12).CreatePivotTable _
        TableDestination:="[Book3.xlsm]Scores!R2C2", TableName:="PivotTable1" _
        , DefaultVersion:=xlPivotTableVersion12