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

[Asha_chandran (asha)]

Hi,

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

[HareeshMR (Hareesh Madasi)]

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

[Asha_chandran (asha)]

Hi Hareesh,

i am checking on it.

-Asha

[Saltukhan_Dura]

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.