DefaultPivotTableLayoutOptions.RowAxisLayout (Excel) Application.DefaultPivotTableLayoutOptions.RowAxisLayout = xlCompactRow