Hi Everyone,

I have around seventy workbooks each with 96 pivot tables in them. Each
workbook has only two differences: the name at the top of each
worksheet in the workbook is different from the titles in other
workbooks and one of the dimensions in each of the pivot tables is
different (again all the same in the same workbook but different in the
other workbooks). I'm trying to find a way of automatically changing
the dimension member in a workbook without having to click each one in
turn (something like a find and replace or perhaps some VBA to do it).

Thanks

Talheedin