I've written a macro that creates a pivot table and names it (options).
I have recorded a second macro that references the first pivot table as its source in order to save memory. When I test the second macro in step-through mode, it goes to debug in the second line when referencing the first macro.
I cannot figure out what is causing this. Is it the cache? As I said, I can do these steps manually and it works fine. Let me know if you need additional info or if this is total mud.

Here is the code of the second pivot table macro

Sub Macro19()
'
    ActiveWorkbook.RefreshAll

'macro goes to debug at this point for this section.
    ActiveWorkbook.Worksheets("PT1 Base vs Comp Hrs").PivotTables("Pvt_DeltaHours") _
        .PivotCache.CreatePivotTable TableDestination:="", TableName:="Dupl_EmpId" _
        , DefaultVersion:=xlPivotTableVersion10
'

    ActiveSheet.PivotTables("Dupl_EmpId").PivotFields("EmployeeName").Subtotals = _
        Array(False, False, False, False, False, False, False, False, False, False, False, False)
    ActiveSheet.PivotTables("Dupl_EmpId").PivotFields("EmpID").Subtotals = Array( _
        False, False, False, False, False, False, False, False, False, False, False, False)
    ActiveSheet.PivotTables("Dupl_EmpId").AddFields RowFields:=Array("EmpID", _
        "EmployeeName")
    ActiveSheet.PivotTables("Dupl_EmpId").PivotFields("BaseHours").Orientation = _
        xlDataField
    ActiveSheet.PivotTables("Dupl_EmpId").PivotFields("EmpID").AutoSort xlAscending _
        , "EmpID"
    ActiveWorkbook.ShowPivotTableFieldList = False
'    ActiveSheet.PivotTables("Dupl_EmpId").PivotCache.Refresh
    ActiveWorkbook.RefreshAll
End Sub