View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Augusto_Madrid Augusto_Madrid is offline
external usenet poster
 
Posts: 9
Default Modify all pivot tables in one sheet

How can I modify all my pivots at once?

I have some 200 PT and I need them to switch from one filtering variable to
another, ie. if I am filtering by "year" and "type of equipment" (as general
filters, not as rows or columns), and I would need "type of equipment"
replaced by "Seller" in all my Pivot Tables

Can this be done?

Thanks in advance!