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.

Hi minimaster,

The grouping settings do not bother me; it's just the data filtering
capabilities that the pivot is used for. However, my client has
decided to forego filtering the data via a pivot table alltogether, and
I'm going to build a VBA data selection userform instead.

Thanks for the answer though!

--
Kind regards,
Carl Colijn

TwoLogs - IT Services and Product Development
A natural choice!
http://www.twologs.com
TimeTraces: the powerful and versatile time registration system!
http://timetraces.twologs.com