{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Awesome","Dashboard","DarkCave","Sheet4","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":5},"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2104]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Engin_Akyurt / Pixabay"]

{"sheet":"Awesome","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Name","Region","Sales",null,"Top 3 Sales Reps",null,null,"Sales by Region"]
["Andy","East",{"$f":"ROW()","v":2}]
["Betty","Central",{"$f":"ROW()","v":3},null,"Name","Sum of Sales",null,"Region","Sum of Sales"]
["Charlie","West",{"$f":"ROW()","v":4},null,"Kevin",34,null,"West",209]
["Della","East",{"$f":"ROW()","v":5},null,"Hank",31,null,"Grand Total",209]
["Eddy","Central",{"$f":"ROW()","v":6},null,"Eddy",28]
["Flo","West",{"$f":"ROW()","v":7},null,"Grand Total",93]
["Gloria","East",{"$f":"ROW()","v":8}]
["Hank","Central",{"$f":"ROW()","v":9}]
["Ike","West",{"$f":"ROW()","v":10}]
["Jack","East",{"$f":"ROW()","v":11}]
["Kevin","Central",{"$f":"ROW()","v":12}]
["Andy","West",{"$f":"ROW()","v":13}]
["Betty","East",{"$f":"ROW()","v":14}]
["Charlie","Central",{"$f":"ROW()","v":15}]
["Della","West",{"$f":"ROW()","v":16}]
["Eddy","East",{"$f":"ROW()","v":17}]
["Flo","Central",{"$f":"ROW()","v":18}]
["Gloria","West",{"$f":"ROW()","v":19}]
["Hank","East",{"$f":"ROW()","v":20}]
["Ike","Central",{"$f":"ROW()","v":21}]
["Jack","West",{"$f":"ROW()","v":22}]
["Kevin","East",{"$f":"ROW()","v":23}]
["Andy","Central",{"$f":"ROW()","v":24}]
["Betty","West",{"$f":"ROW()","v":25}]
["Charlie","East",{"$f":"ROW()","v":26}]
["Della","Central",{"$f":"ROW()","v":27}]
["Eddy","West",{"$f":"ROW()","v":28}]
["Flo","East",{"$f":"ROW()","v":29}]
["Gloria","Central",{"$f":"ROW()","v":30}]
["Hank","West",{"$f":"ROW()","v":31}]
["Ike","East",{"$f":"ROW()","v":32}]
["Jack","Central",{"$f":"ROW()","v":33}]
["Kevin","West",{"$f":"ROW()","v":34}]

{"sheet":"Dashboard","index":2,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Name","Region","Sales",null,"Name","Region","Profit"]
["Andy",{"$f":"VLOOKUP(A2,$E$2:$F$12,2,0)","v":"East"},{"$f":"ROW()","v":2},null,"Andy","East",{"$f":"C2/2","v":1},null,"Name","Sum of Sales",null,"Name","Sum of Profit"]
["Betty",{"$f":"VLOOKUP(A3,$E$2:$F$12,2,0)","v":"West"},{"$f":"ROW()","v":3},null,"Betty","West",{"$f":"C3/2","v":1.5},null,"Andy",39,null,"Andy",1]
["Charlie","Central",{"$f":"ROW()","v":4},null,"Charlie","Central",2,null,"Betty",42,null,"Betty",1.5]
["Della","East",{"$f":"ROW()","v":5},null,"Della","East",2.5,null,"Charlie",45,null,"Charlie",2]
["Eddy","West",{"$f":"ROW()","v":6},null,"Eddy","West",3,null,"Della",48,null,"Della",2.5]
["Flo","Central",{"$f":"ROW()","v":7},null,"Flo","Central",3.5,null,"Eddy",51,null,"Eddy",3]
["Gloria","East",{"$f":"ROW()","v":8},null,"Gloria","East",4,null,"Flo",54,null,"Flo",3.5]
["Hank","West",{"$f":"ROW()","v":9},null,"Hank","West",4.5,null,"Gloria",57,null,"Gloria",4]
["Ike","Central",{"$f":"ROW()","v":10},null,"Ike","Central",5,null,"Hank",60,null,"Hank",4.5]
["Jack","East",{"$f":"ROW()","v":11},null,"Jack","East",5.5,null,"Ike",63,null,"Ike",5]
["Kevin","West",{"$f":"ROW()","v":12},null,"Kevin","West",6,null,"Jack",66,null,"Jack",5.5]
["Andy","East",{"$f":"ROW()","v":13},null,null,null,null,null,"Kevin",69,null,"Kevin",6]
["Betty","West",{"$f":"ROW()","v":14},null,null,null,null,null,"Grand Total",594,null,"Grand Total",38.5]
["Charlie","Central",{"$f":"ROW()","v":15}]
["Della","East",{"$f":"ROW()","v":16}]
["Eddy","West",{"$f":"ROW()","v":17}]
["Flo","Central",{"$f":"ROW()","v":18}]
["Gloria","East",{"$f":"ROW()","v":19}]
["Hank","West",{"$f":"ROW()","v":20}]
["Ike","Central",{"$f":"ROW()","v":21}]
["Jack","East",{"$f":"ROW()","v":22}]
["Kevin","West",{"$f":"ROW()","v":23}]
["Andy","East",{"$f":"ROW()","v":24}]
["Betty","West",{"$f":"ROW()","v":25}]
["Charlie","Central",{"$f":"ROW()","v":26}]
["Della","East",{"$f":"ROW()","v":27}]
["Eddy","West",{"$f":"ROW()","v":28}]
["Flo","Central",{"$f":"ROW()","v":29}]
["Gloria","East",{"$f":"ROW()","v":30}]
["Hank","West",{"$f":"ROW()","v":31}]
["Ike","Central",{"$f":"ROW()","v":32}]
["Jack","East",{"$f":"ROW()","v":33}]
["Kevin","West",{"$f":"ROW()","v":34}]

{"sheet":"DarkCave","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet4","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name","Sum of Profit"]
[null,null,"Andy",1]
[null,null,"Betty",1.5]
[null,null,"Charlie",2]
[null,null,"Della",2.5]
[null,null,"Eddy",3]
[null,null,"Flo",3.5]
[null,null,"Gloria",4]
[null,null,"Hank",4.5]
[null,null,"Ike",5]
[null,null,"Jack",5.5]
[null,null,"Kevin",6]
[null,null,"Grand Total",38.5]

{"sheet":"Wrap Up","index":5,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"How can you have a slicer drive two pivot tables?"]
[null,"If both pivot tables came from the same data set: Select Slicer, Report Connections, Choose Other Pivot Tables"]
[null,"But if the pivot tables came from different data sets: "]
[null,"Use Save As to change the workbook extension to XLSM instead of XLSX"]
[null,"Use Alt+T M S and change macro security to second setting."]
[null,"Alt+F11 to get to VBA"]
[null,"Ctrl+R to display the project explorer"]
[null,"Find the worksheet that contains your first pivot table and slicer"]
[null,"Insert the code for Worksheet_Update"]
[null,"Hide the second slicer away so it keeps existing but no one can ever choose from that slicer"]