{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Sheet1","Data","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":2},"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,2079]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: sign/post/1e930eb4-9a54-444b-ada5 / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Product","Category","Units","Result"]
["Dill","Herb",7,140]

{"sheet":"Data","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Factor",20]
[]
["Product","Category","Units","Result",null,"Brand","Category","Units","Result",null,"Category","Sum of Result"]
["Apple","Fruit",4,{"$f":"+C4*$B$1","v":80},null,"Alfa Romeo","Sports Car",185,{"$f":"+H4*$B$1","v":3700},null,"Citrus",280]
["Banana","Fruit",5,{"$f":"+C5*$B$1","v":100},null,"Buick","GM",156,{"$f":"+H5*$B$1","v":3120},null,"Fruit",2260]
["Cherry","Fruit",6,120,null,"Chevy","GM",196,3920,null,"Herb",140]
["Dill","Herb",7,140,null,"Dodge","Chrysler",184,3680,null,"Nut",320]
["Eggplant","Vegetable",8,160,null,"Fiat","Sports Car",114,2280,null,"Vegetable",1500]
["Fig","Fruit",9,180,null,"Huffy","Bicycle",183,3660,null,"Grand Total",4500]
["Guava","Fruit",10,200,null,"Infiniti","Car",138,2760]
["Huckleberry","Fruit",11,220,null,"Jaguar","Sports Car",155,3100]
["Jicama","Vegetable",12,240,null,"Kia","Car",137,2740,null,"Category","Sum of Result"]
["Kiwi","Fruit",13,260,null,"Lamborghini","Sports Car",200,4000,null,"Bicycle",6460]
["Lime","Citrus",14,280,null,"Mack","Truck",116,2320,null,"Car",12980]
["Melon","Fruit",15,300,null,"Ram","Truck",119,2380,null,"Chrysler",3680]
["Nuts","Nut",16,320,null,"Subaru","Car",187,3740,null,"GM",7040]
["Olive","Vegetable",17,340,null,"Tesla","Sports Car",193,3860,null,"Sports Car",16940]
["Pepper","Vegetable",18,360,null,"VW","Car",187,3740,null,"Truck",9480]
["Quince","Fruit",19,380,null,"Caterpillar","Truck",132,2640,null,"Grand Total",56580]
["Radish","Vegetable",20,400,null,"Kenworth","Truck",107,2140]
["Strawberry","Fruit",21,420,null,"Schwinn","Bicycle",140,2800]
[]
["Ugli"]

{"sheet":"Wrap Up","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Say that you have two pivot tables from different data."]
[null,"The original data changes in both data sets. You want to refresh all pivot tables."]
[null,"The Refresh button on the PivotTable Tools | Analyze tab only refreshes one pivot table."]
[null,"Use Ctrl+Alt+F5 or Data, Refresh All to refresh all pivot tables in the workbook"]