On Tue, 5 Apr 2011 00:53:27 -0700 (PDT), minimaster
wrote:

I have written an add-in for myself that allows to save a pivottable
layout with all setttings and then I can restore this saved layout
when I want to.
Because there are problems to read certain filterings, as you
discovered,, I'm temporarly changing the field orientation, then
reading the filtering, and then restoring the field to its original
orientation.

I still have a one problem with the grouping of data, e.g. when dates
are grouped by months, quarters,.. I found no way that I can read the
current grouping settings. Looks like MS forgot to implement it. I can
set with VBA or VB.net the grouping but i didn't find a straightfwd
way to read the grouping settings.

right click on a header of the pivot table?