Pivot table question

Question

You recently had a question on changing the page fields in a pivot table and having those changes made in 4 other pivot tables. The questioner cited some code he had found - and you stated you didn't think it was you answer. The code cited was from a question - not from an answer. I worked with the person (via email) who wrote the question to get it fixed for them. Also, you said you would recommend using formulas, but I would be hard pressed to see how you are going to change pivot table page field selections using formulas but maybe you know something I don't. -- All the best, Tom Ogilvy

Answer

-