{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","datasource"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":6},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using one Slicer to Control Single Pivot Tables on Multiple Worksheets with Different Data Sources",null,null,null,null,null,null,null,null,null,null,"2015-04-25"]
[null,"Synchronisation of individual Pivot Tables on Multiple Worksheets / Hidden Slicers from a single Main Slicer"]
[null,"by Mark Kubiszyn"]
[]
[null,"PivotTable1",null,null,null,null,"PivotTable4"]
[]
[null,"Type","Size","Sum of Volume",null,null,"Category","Sum of Count of SKUS"]
[null,1,"Keg",10000,null,null,"Soft Drinks",248]
[null,3,"Bottle",12000]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Info:"]
[null,null,null,null,null,null,null,null,null,"Right-click any Worksheet Tab and Unhide the hidden \"datasource\" Worksheet"]
[null,null,null,null,null,null,null,null,null,"Look at the \"datasource\" Worksheet to see the hidden Slicers and different datasources for all 3 Pivot Tables"]
[null,null,null,null,null,null,null,null,null,"When you select a Slicer Item from the 'Slicer_Type' Slicer on this Worksheet, all of the Pivot Tables on all of the other Worksheets will be Sliced by the same selections"]
[null,null,null,null,null,null,null,null,null,"I have sorted the Pivot Tables by Type ascending, so selecting 1 & 4 will Slice items in this order"]
[]
[null,null,null,null,null,null,null,null,null,"Use CTRL+Left Mouse Click to select Multiple Items"]
[null,null,null,null,null,null,null,null,null,"Use the Filter to reset all of the Items"]
[]
[]
[]
[]
[null,"Slicer_Type"]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PivotTable2 (with 1 extra Column)",null,null,null,null,"PivotTable5"]
[]
[null,"Type","Size","Volume","No. in Pack",null,"Category","Sum of Count of SKUS"]
[null,1,"Keg",10000,1,null,"Soft Drinks",248]
[null,3,"Bottle",12000,24]

{"sheet":"Sheet3","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PivotTable3",null,null,null,null,"PivotTable6"]
[]
[null,"Type","Size","Sum of Volume",null,null,"Category","Sum of Count of SKUS"]
[null,1,"CASK",5000,null,null,"Soft Drinks",248]
[null,3,"Bottle",12000]

{"sheet":"datasource","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Type","Volume","Size",null,"Type","Volume","Size","Number",null,"Type","Volume","Size",null,"Category","Count of SKUS",null,"Category","Count of SKUS",null,"Category","Count of SKUS"]
[1,10000,"Keg",null,4,20000,"Bottle",12,null,1,5000,"CASK",null,"Wines & Spirits",1204,null,"Wines & Spirits",1204,null,"Wines & Spirits",1204]
[3,12000,"Bottle",null,3,12000,"Bottle",24,null,2,10000,"Keg",null,"Beer",587,null,"Beer",587,null,"Beer",587]
[2,5000,"CASK",null,1,10000,"Keg",1,null,3,12000,"Bottle",null,"Soft Drinks",248,null,"Soft Drinks",248,null,"Soft Drinks",248]
[4,20000,"Bottle",null,2,5000,"CASK",1,null,4,20000,"Bottle"]
[null,null,null,null,null,null,null,null,null,4,16000,"Bottle"]
[null,null,null,null,null,null,null,null,null,2,4000,"Keg"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Slicer_Type1",null,null,null,null,"Slicer_Type2",null,null,null,"Slicer_Category1",null,null,"Slicer_Category2"]