Export pivot table label and value filter selections

[drewg]

Hi
Is it possible to export the settings in effect when selected?
We drive ton of reports from the same table.
Some reports need manually selected filter criteria.
We would like to memorialize them as either a formula, macro, or VBA routine so that these can be reliably reset by someone other than a subject matter expert

 

[Chihiro]

Try using Macro Recorder and record each filter operation. Also recording when filters are removed.

This will give you basic set up which can be assigned to buttons to add and remove filters.

 

[drewg]

Try using Macro Recorder and record each filter operation. Also recording when filters are removed.

This will give you basic set up which can be assigned to buttons to add and remove filters.

What a great idea! It should capture what I need with a minimum of effort or error.
thanks a ton, I really appreciate your insight.