{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","PivotTable","Dataset_Refresh","Pivot Table_Refresh","Datset_Table","PivotTable_ExcelTable","Dynamic_Range","PivotTable_Dynamic","Dataset_VBA","PivotTable_VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset with New Data"]
[]
[null,"Product Category","States","Quantity","Sales"]
[null,"Fruit","Ohio",10,1000]
[null,"Electronics","Florida",20,4000]
[null,"Vegetable","Texas",30,1000]
[null,"Food","Hawaii",40,2000]
[null,"Furniture","Ohio",20,3000]
[null,"Fruit","Florida",20,1500]
[null,"Electronics","Texas",30,2500]
[null,"Vegetable","California",50,1500]
[null,"Food","Arizona",30,2000]
[null,"Furniture","Texas",30,3000]
[null,"Electronics","Arizona",30,4000]

{"sheet":"PivotTable","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Updating Pivot Table Range Manually"]
["Sum of Sales","Column Labels"]
["Row Labels","Florida","Hawaii","Ohio","Texas","California","Arizona","Grand Total"]
["Electronics",4000,null,null,2500,null,4000,10500]
["Food",null,2000,null,null,null,2000,4000]
["Fruit",1500,null,1000,null,null,null,2500]
["Furniture",null,null,3000,3000,null,null,6000]
["Vegetable",null,null,null,1000,1500,null,2500]
["Grand Total",5500,2000,4000,6500,1500,6000,25500]

{"sheet":"Dataset_Refresh","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset with New Data"]
[]
[null,"Product Category","States","Quantity","Sales"]
[null,"Fruit","Ohio",10,1000]
[null,"Electronics","Florida",20,4000]
[null,"Vegetable","Texas",30,1000]
[null,"Food","Hawaii",40,2000]
[null,"Furniture","Ohio",20,3000]
[null,"Fruit","Florida",20,1500]
[null,"Electronics","Texas",30,2500]
[null,"Vegetable","California",50,1500]
[null,"Food","Arizona",30,2000]
[null,"Furniture","Texas",30,3000]
[null,"Electronics","Arizona",30,4000]

{"sheet":"Pivot Table_Refresh","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Updating Pivot Table by Clicking Refresh"]
["Sum of Sales","Column Labels"]
["Row Labels","California","Florida","Hawaii","Ohio","Texas","Arizona","Grand Total"]
["Electronics",null,4000,null,null,2500,4000,10500]
["Food",null,null,2000,null,null,2000,4000]
["Fruit",null,1500,null,1000,null,null,2500]
["Furniture",null,null,null,3000,3000,null,6000]
["Vegetable",1500,null,null,null,1000,null,2500]
["Grand Total",1500,5500,2000,4000,6500,6000,25500]

{"sheet":"Datset_Table","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"New Data in Excel Table"]
[]
[null,"Product Category","States","Quantity","Sales"]
[null,"Fruit","Ohio",10,1000]
[null,"Electronics","Florida",20,4000]
[null,"Vegetable","Texas",30,1000]
[null,"Food","Hawaii",40,2000]
[null,"Furniture","Ohio",20,3000]
[null,"Fruit","Florida",20,1500]
[null,"Electronics","Texas",30,2500]
[null,"Vegetable","California",50,1500]
[null,"Food","Arizona",30,2000]
[null,"Furniture","Texas",30,3000]
[null,"Electronics","Arizona",30,4000]

{"sheet":"PivotTable_ExcelTable","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Updating Pivot Table Range by Creating Excel Table"]
["Sum of Sales","Column Labels"]
["Row Labels","California","Florida","Hawaii","Ohio","Texas","Arizona","Grand Total"]
["Electronics",null,4000,null,null,2500,4000,10500]
["Food",null,null,2000,null,null,2000,4000]
["Fruit",null,1500,null,1000,null,null,2500]
["Furniture",null,null,null,3000,3000,null,6000]
["Vegetable",1500,null,null,null,1000,null,2500]
["Grand Total",1500,5500,2000,4000,6500,6000,25500]

{"sheet":"Dynamic_Range","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Updating Pivot Table Range Using OFFSET Function"]
[]
[null,"Product Category","States","Quantity","Sales"]
[null,"Fruit","Ohio",10,1000]
[null,"Electronics","Florida",20,4000]
[null,"Vegetable","Texas",30,1000]
[null,"Food","Hawaii",40,2000]
[null,"Furniture","Ohio",20,3000]
[null,"Fruit","Florida",20,1500]
[null,"Electronics","Texas",30,2500]
[null,"Vegetable","California",50,1500]
[null,"Food","Arizona",30,2000]
[null,"Furniture","Texas",30,3000]
[null,"Electronics","Arizona",30,4000]

{"sheet":"PivotTable_Dynamic","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Updating Pivot Table Range Using OFFSET Function"]
["Sum of Sales","Column Labels"]
["Row Labels","California","Florida","Hawaii","Ohio","Texas","(blank)","Arizona","Grand Total"]
["Electronics",null,4000,null,null,2500,null,4000,10500]
["Food",null,null,2000,null,null,null,2000,4000]
["Fruit",null,1500,null,1000,null,null,null,2500]
["Furniture",null,null,null,3000,3000,null,null,6000]
["Vegetable",1500,null,null,null,1000,null,null,2500]
["(blank)"]
["Grand Total",1500,5500,2000,4000,6500,null,6000,25500]

{"sheet":"Dataset_VBA","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Updating Pivot Table Range Using VBA Code"]
[]
[null,"Product Category","States","Quantity","Sales"]
[null,"Fruit","Ohio",10,1000]
[null,"Electronics","Florida",20,4000]
[null,"Vegetable","Texas",30,1000]
[null,"Food","Hawaii",40,2000]
[null,"Furniture","Ohio",20,3000]
[null,"Fruit","Florida",20,1500]
[null,"Electronics","Texas",30,2500]
[null,"Vegetable","California",50,2000000]

{"sheet":"PivotTable_VBA","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Updating Pivot Table Range Using VBA"]
["Sum of Sales","Column Labels"]
["Row Labels","California","Florida","Hawaii","Ohio","Texas","Grand Total"]
["Electronics",null,4000,null,null,2500,6500]
["Food",null,null,2000,null,null,2000]
["Fruit",null,1500,null,1000,null,2500]
["Furniture",null,null,null,3000,null,3000]
["Vegetable",2000000,null,null,null,1000,2001000]
["Grand Total",2000000,5500,2000,4000,3500,2015000]