"Run time error 1004" - unable to get the pivotitems property of the pivotfield class


Can anyone help me with the below error. When i run the macros in excel i get the below error.

image excelerror

Are you sure you have the column with the name you are trying to pull to the pivot table @Asha_chandran?

Hi Hareesh,

i am checking on it.


any updates about it? I am having the same problem. I am sure I have the right column name or sth else. @HareeshMR

I already have the Pivot table. I just need to adjust it to Tabular view with PivotTable Fieldsettings.