Microsoft Office Tutorials and References
In Depth Information
Synchronizing Page Fields of Pivot Tables
LogInfo Target¶
End If¶
End Sub¶
Synchronizing Page Fields of Pivot Tables
Use this procedure to overcome the limitation of Pivot Tables that do not stay
synchronized whenever one of the Page fields is changed.
Exl
Example file:
E042.xls
Scenario: When you use a workbook that contains multiple
tables based on the same database, displaying the
information in a different way can become a real hassle.
There is no way in Excel to "lock" the Page fields of pivot
tables to display the same item, making it possible to easily
compare the information between separate pivot tables.
This sample shows how to lock all the pivot tables in a
worksheet or workbook, such that changing a page field in
one affects the rest of the pivot tables as well.
Figure 43 – Synchronizing Pivot Table Page Fields
 
Search JabSto ::




Custom Search