I'm looking to get the complete criteria for summarized fields in the
DATA area of the pivot table.

If the pivot tables were straight from the external datasource I would
happily extract the SQL statement, or if they were formula based I
could easily 'back-track' them. However I can't find an easy was of
getting the criteria for range based pivot tables.

Sorry if this seems a bit vague, I am relatively new to the Pivottable
(and related objects) model.

Giff