Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class' Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class' vba vba

Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class'


As JosieP said in the comments, the 1004 error means that there is no such object, that is there is no such pivot field that is called "Row Labels".


I may add an extra answer (as I found nothing on that):

For people working with Data Model Pivot Tables, field names are not obvious ([tablename].[fieldname].[fieldname2]).Hence I suggest using following loop to understand what fields are currently in your pivot table:

Dim pt As PivotTableDim pf As PivotFieldSet pt = ActiveSheet.PivotTables(ptName)For Each pf In pt.PivotFields    Debug.Print pf.NameNext

This way you'll have all the names listed in the immediate view.