With ActiveSheet.PivotTables("PivotTable1").PivotFields("Item") :="PivotTable1", DefaultVersion:=xlPivotTableVersion10ĪctiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1) "'Data Entry'!R4C3:R170C7").CreatePivotTable TableDestination:="", TableName _ They get an error "Compile Error/ Named Argument not found" The error seems to have to do with "Defaultversion:=x"Īny help with solving this problem would be greatly appreciated!Ī(SourceType:=xlDatabase, SourceData:= _ They all are on Excel 2000 and the Macro does not work when they try to run it. The reason was that I needed to create a quick way for the employees that work for me do some reporting. I have a Macro that was created in Excel 2003.
0 kommentar(er)
