I have a pivot table with two levels in Row Labels.

We change the filters often in that pivot table. Every time we change some of the entries are expanded. That's annoying. I don't want the pivot table to expand rows unless I manually expand them.

Is that possible?

Also, is it possible to do COLLAPSE ENTIRE FIELD to ALL the pivot tables in the excel?

Thanks