I wonder if the target worksheet must be actually named, vs the default Sheet1, Sheet2, Sheet3, etc etc
Quote:
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"'Raw Data'!R2C1:R" & RowCount & "C54").CreatePivotTable TableDestination:= _
[MBR Prep Work 1.1.xls]Sheet2'!R1C16
|
Would that actually make a difference?