I recorded a Macro of me creating a pivot table then attempted to step through the execution (after removing the one I had created) and I get an error on this line;
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"NRDetails[#All]", Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Not Ready Summary!R3C1", TableName:="PivotTable1", _
"NRDetails[#All]" refers to a table on another worksheet.
I've tried changing the name of the worksheet in case there was a remnant in memory of the table name but that didn't change anything.
What am I missing?