I'm in the process of locking down a pivot table to users are restrcted to
processes that keep in the same shape and allow the next user to see all
available data. While writing code to reverse user-hidden PivotItems, I
noticed some old Pivot Item references that no longer exist in the data but
still have a check-box. Is there way to clean up hang-overs from previous
data?

Steve

There's information here on clearing old items in a pivot table:

http://www.contextures.com/xlPivot04.html


Steve wrote:
I'm in the process of locking down a pivot table to users are restrcted to
processes that keep in the same shape and allow the next user to see all
available data. While writing code to reverse user-hidden PivotItems, I
noticed some old Pivot Item references that no longer exist in the data but
still have a check-box. Is there way to clean up hang-overs from previous
data?

Steve


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra
Thank you. While I've been programming spreadsheets for about five years or
so following some years Access experience, this is my first venture into
controlling pivots with VBA - never could adjust to calling it 'macros'. I
recall drawing knowledge from your site previously (as against pinching code
snippets) but (obviously) didn't recall your pivot tips. Thank you for
making this and other information available.

Steve

"Debra Dalgleish" wrote in message
...
There's information here on clearing old items in a pivot table:

http://www.contextures.com/xlPivot04.html


Steve wrote:
I'm in the process of locking down a pivot table to users are restrcted
to processes that keep in the same shape and allow the next user to see
all available data. While writing code to reverse user-hidden PivotItems,
I noticed some old Pivot Item references that no longer exist in the data
but still have a check-box. Is there way to clean up hang-overs from
previous data?

Steve


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome, and thanks for letting me know that it helped.

Steve wrote:
Debra
Thank you. While I've been programming spreadsheets for about five years or
so following some years Access experience, this is my first venture into
controlling pivots with VBA - never could adjust to calling it 'macros'. I
recall drawing knowledge from your site previously (as against pinching code
snippets) but (obviously) didn't recall your pivot tips. Thank you for
making this and other information available.

Steve

"Debra Dalgleish" wrote in message
...

There's information here on clearing old items in a pivot table:

http://www.contextures.com/xlPivot04.html


Steve wrote:

I'm in the process of locking down a pivot table to users are restrcted
to processes that keep in the same shape and allow the next user to see
all available data. While writing code to reverse user-hidden PivotItems,
I noticed some old Pivot Item references that no longer exist in the data
but still have a check-box. Is there way to clean up hang-overs from
previous data?

Steve


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html