Run pivot table code

[tiredofit]

I recorded a macro to create a pivot table, then manually deleted it.

When I ran the recorded code, it failed here:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
        "Imported Data!R1C1:R100C7", Version:=6).CreatePivotTable TableDestination _
        :="Imported Data!R3C10", TableName:="PivotTable3", DefaultVersion:=6

with a message of Invalid procedure call or argument.

What is wrong?

EDIT: SORTED

https://support.microsoft.com/en-gb/help/940166/error-message-when-you-play-a-recorded-macro-to-create-a-pivottable-in