Show all Pivot Table items

[joebanana]

Is there a faster way than a loop with

Please Login or Register  to view this content.

I have thousands of items to show. Isn't there a quick Show All somehow?

[arlu1201]

Try this code

Please Login or Register  to view this content.

[joebanana]

Arlette, thanks, but ShowAllItems doesn't do that.

What it does is affecting the way "empty" items show (when count is 0 for example).
It doesn't select all items from the list.

[JosephP]

replace that line with

Please Login or Register  to view this content.

[joebanana]

Unfortunately this affects only filters.

I need to update the table itself. It that can help, my table is in a tabular format.

[JosephP]

you've lost me. if I manually hide items in a row field using the drop down list, that code will reset all items to visible-were you talking about something else?

[joebanana]

You're right!

I tried this before and it didn't work, now it's working... go figure.

Thanks!