{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Refresh All","Mouse","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Overview","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview"]
[]
[null,"Sales Rep","Products","Quantity","Rev Earned"]
[null,"Karl","Laptop",5,250000]
[null,"Russel","Macbook",2,150000]
[null,"Dalton","Desktop",6,120000]
[null,"Williamson","Mobile",8,80000,null,null,"Tom","Laptop",3,150000]
[null,"Andry","Laptop",2,150000]
[null,"Brine","Macbook",4,250000]
[null,"Finch","Laptop",3,150000]
[null,"Carlos","Mobile",9,180000]
[null,"John","Laptop",3,150000]

{"sheet":"Refresh All","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[0,1,0,5]]}
[null,"Refresh All Command to Refresh All Pivot Tables in Excel"]
[null,"Pivot Table 1",null,null,"Pivot Table 2"]
[]
[null,"Sales Rep","Sum of Rev Earned",null,"Products","Sum of Quantity"]
[null,"Andry",150000,null,"Desktop",6]
[null,"Brine",250000,null,"Laptop",13]
[null,"Carlos",180000,null,"Macbook",6]
[null,"Dalton",120000,null,"Mobile",17]
[null,"Finch",150000,null,"Grand Total",42]
[null,"Karl",250000]
[null,"Russel",150000]
[null,"Williamson",80000]
[null,"John",150000]
[null,"Grand Total",1480000]

{"sheet":"Mouse","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,2],[1,4,1,5]]}
[null,"Mouse Command to Refresh All Pivot Tables in Excel"]
[null,"Pivot Table 1",null,null,"Pivot Table 2"]
[]
[null,"Sales Rep","Sum of Rev Earned",null,"Products","Sum of Quantity"]
[null,"Andry",150000,null,"Desktop",6]
[null,"Brine",250000,null,"Laptop",13]
[null,"Carlos",180000,null,"Macbook",6]
[null,"Dalton",120000,null,"Mobile",17]
[null,"Finch",150000,null,"(blank)"]
[null,"Karl",250000,null,"Grand Total",42]
[null,"Russel",150000]
[null,"Williamson",80000]
[null,"John",150000]
[null,"Grand Total",1480000]

{"sheet":"VBA","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,2],[1,4,1,5]]}
[null,"Run a VBA Code to Refresh All Pivot Tables in Excel"]
[null,"Pivot Table 1",null,null,"Pivot Table 2"]
[]
[null,"Sales","Sum of Rev Earned",null,"Products","Sum of Quantity"]
[null,"Andry",150000,null,"Desktop",6]
[null,"Brine",250000,null,"Laptop",13]
[null,"Carlos",180000,null,"Macbook",6]
[null,"Dalton",120000,null,"Mobile",17]
[null,"Finch",150000,null,"Grand Total",42]
[null,"Karl",250000]
[null,"Russel",150000]
[null,"Williamson",80000]
[null,"John",150000]
[null,"Grand Total",1480000]