Pivot table question

[Mr930]

I have a bunch of pivot tables across multiple sheets, each with identical structure. The only difference would be the value on a filter. Is it possible to change all of them at once for the fields I want to display? It does not look like it will let me do that. I tried to change all of the data ranges at the same time with no luck.

thanks
Fred Emmerich

 

[Juan Pablo González]

Maybe this will help? Look at file PT0016 here:

http://www.contextures.com/excelfiles.html