I tried that and unfortunately, I think it told me there was too much data to
store and gave me an error. I was hoping you would be the one to respond.
As I reviewed some of the questions, you seemed to have some really great
solutions. This file is huge and I'm not sure there is such a solution.
It's a shame, because it would been a great tool if I could create it.

"Debra Dalgleish" wrote:

> Custom Views don't store pivot table settings. Perhaps you could record
> a macro as you make selections from the pivot field dropdown lists.
> Then, run that macro to reapply the selections.
>
> kza40381 wrote:
> > Is there a way to save a view (not just settings), but specific filtering
> > choices in a pivot table, i.e. If you want to create different groups
> > specifically based on the filtered criteria, you could just select a "view
> > name" and get the group you request?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>