hoppermr2004
New Member
- Joined
- Dec 9, 2008
- Messages
- 9
I have multiple data items in my pivot table. If I click on the grey 'Data' tab drop down, I can hide data fields that I don't wish to view by unticking them (this shouldn't be confused with hiding row or column data fields although the effect is the same).
The equivalent VBA command would be :-
Sheet1.PivotFields("Sum of No Records").Orientation = xlHidden
If I wish to unhide a data field hiden in this way, that item is no longer in the data field drop down box. Effectively the pivot table has removed the data field from the pivot rather than hidden it.
Is there any way to effectivly 'hide' and then 'unhide' data items without having to drag the data field back into the pivot?
Thanks dudes
The equivalent VBA command would be :-
Sheet1.PivotFields("Sum of No Records").Orientation = xlHidden
If I wish to unhide a data field hiden in this way, that item is no longer in the data field drop down box. Effectively the pivot table has removed the data field from the pivot rather than hidden it.
Is there any way to effectivly 'hide' and then 'unhide' data items without having to drag the data field back into the pivot?
Thanks dudes