{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PivotTbl","Dataset"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"PivotTbl","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Refreshing Pivot Table with VBA"]
[]
[null,"Product","Price ($)","Quantity","Total"]
[null,"Book",10,7,70]
[null,"Bottle",15,9,135]
[null,"Eraser",2,5,10]
[null,"Notepad",7,12,84]
[null,"Pen",5,10,50]
[null,"Pencil",3,8,24]
[null,"Grand Total",42,51,373]

{"sheet":"Dataset","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for the Pivot Table"]
[]
[null,"Product","Price","Amount","Total Price"]
[null,"Pen",5,10,{"$f":"C5*D5","v":50}]
[null,"Pencil",3,8,{"$f":"C6*D6","v":24}]
[null,"Eraser",2,5,10]
[null,"Book",10,7,70]
[null,"Notepad",7,12,84]
[null,"Bottle",15,9,135]