PivotFields
 

I get this error and I don't know how to fix it. "Unable to get the
PivotFields property of the Pivot Table Class." What does this mean and does
anyone know how to fix it. Thank you in advance....

PivotFields
 

Hi Neal,
It occurs when the field name used does not exist. Eg:
Dim f As PivotField
Set f = ActiveSheet.PivotTables(1).PivotFields("a")
If field "A" does not exist, it fails.

Try to display your filed names:
? ActiveSheet.PivotTables(1).PivotFields(1).Name 'then 2,3,4...
And make su
- the field name exist
- you are referencing the right pivot on the right sheet.

Regards,
Sebastien

"Neal" wrote:

I get this error and I don't know how to fix it. "Unable to get the
PivotFields property of the Pivot Table Class." What does this mean and does
anyone know how to fix it. Thank you in advance....

PivotFields
 

sebastien you rock!!!

"sebastienm" wrote:

Hi Neal,
It occurs when the field name used does not exist. Eg:
Dim f As PivotField
Set f = ActiveSheet.PivotTables(1).PivotFields("a")
If field "A" does not exist, it fails.

Try to display your filed names:
? ActiveSheet.PivotTables(1).PivotFields(1).Name 'then 2,3,4...
And make su
- the field name exist
- you are referencing the right pivot on the right sheet.

Regards,
Sebastien

"Neal" wrote:

I get this error and I don't know how to fix it. "Unable to get the
PivotFields property of the Pivot Table Class." What does this mean and does
anyone know how to fix it. Thank you in advance....