Hi,

I use pivot tables to extract data from a large source of data and filter it by a relevant field, then share each individual pivot table to the relevant person...

Whenever I make a change to the source data template (Such as renaming a column, or adding one) I have to apply this change to every single pivot table manually...

Is there a faster way to do this? I currently go into each pivot table and use the wizard then layout to add the new column, have recently considered only changing 1 pivot table then copy pasting it; as changing what the filter is, is a lot easier than adding the changes to each one (duh, I'm silly for not seeing this till now.)

But while I'm at it I thought I'd ask you smart chaps if you know of an even faster way? Thanks very much.

(Sorry about the title. Limited space.)