Pivot table and macro Synchronize pivot tables
Posted by Nona Sloven on May 07, 2001 8:49 AM
I have made three pivot tables in Excel97. The second and third I made them based on the first one and they are in the same workbook; also, the three have exactly the same fields and format, and also made with the same data. Does any one of you know how to synchonize my three pivot tables so that when I select a specific page in the first table (which is the main pivot table), the second and third be selected with the same item or page. I mean, if I select and item in the drop down list, say, Cab, I need the other pivot tables be selected by the item Cab automatically in their drop down lists and not that they have to be selected manually; although I also should be able to select and item manually in each of them. One last consideration is that the fields to be synchronized are the same cells F12 and I12 in the three tables. They should work either if I select F12 or If I select I12. I know this is only possible with a macro because you cannot enter a formula in a pivot table field. If any one of you knows how to come up with this please help. Thanks.