Hi all,
Most people, by now, already know the problem Excel has when you try to deactivate an item in a pivot table. Most users recommend the solution by Debra Dalgleish. However, I get the same error, even when I set the autosort to manual... Could you please help me?
Sample of the code:
With pt1.PivotFields("CREATE_DATE")
.AutoSort xlManual, "CREATE_DATE"
'.PivotItems(5).Visible = True 'Tried this does not work...
.PivotItems("14/12/2011").Visible = True 'this expression is equal to the one recorded _ by the macro recorder and it still does not work
End With
When, in the autosort options, instead of "CREATE_DATE" I write .SourceName, I still get the same error message...
I'm borderline desperate. =D
Most people, by now, already know the problem Excel has when you try to deactivate an item in a pivot table. Most users recommend the solution by Debra Dalgleish. However, I get the same error, even when I set the autosort to manual... Could you please help me?
Sample of the code:
With pt1.PivotFields("CREATE_DATE")
.AutoSort xlManual, "CREATE_DATE"
'.PivotItems(5).Visible = True 'Tried this does not work...
.PivotItems("14/12/2011").Visible = True 'this expression is equal to the one recorded _ by the macro recorder and it still does not work
End With
When, in the autosort options, instead of "CREATE_DATE" I write .SourceName, I still get the same error message...
I'm borderline desperate. =D