{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Q1","Q2","Q3"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"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":"Q1","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[20,6,22,8]]}
["I have a column of values and a total below it. When I insert a new row at the bottom of the column, the total formula doesn't update. How can I fix this?"]
[]
[]
[]
["Continent","Country","City","Date","Name","Sales"]
["Africa"," Morocco"," Tetuan","2022-04-03","Jack",621]
["Africa"," Morocco"," Tangier","2022-03-01","Jack",757]
["America","Canada","Montreal","2022-11-09","Jack",357]
["America"," USA"," Miami","2022-06-17","Jack",657]
["America"," USA"," New York","2022-04-05","Jack",30]
["America","Canada","Vancouver","2022-10-16","John",792]
["America"," Bahamas","Vancouver","2022-10-04","John",741]
["Europe","UK","London","2022-06-29","John",451]
["Europe","UK","London","2022-05-31","John",850]
["Europe","UK","Manchester","2022-03-08","John",258]
["Asia"," Cambodia"," Phnom Penh","2022-05-08","John",564]
["Asia"," Cambodia","Siem Reap","2022-10-15","Josie",640]
["Asia"," Cambodia"," Phnom Penh","2022-11-12","Josie",281]
["Europe"," France"," Mulhouse","2022-11-30","Josie",526]
[null,null,null,null,null,null,"<<< if you type a value in here the formula will update!"]
[null,null,null,null,null,{"$f":"SUBTOTAL(109,F6:F19)","v":7525},"<<< using SUBTOTAL instead of SUM (and the 1xx range of options) ensures that the function is only applied to the visible cells"]
[]
[]
[]
[]
[]
["TRIMRANGE Announcement"]

{"sheet":"Q2","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["I need to send an Excel file to someone but it's too big - is there anything I can do in Excel to make it smaller?"]
[]
["1- Check performance"]
[]
["Excel Tips and Tricks #496 – ‘Check Performance’ in Excel | ICAEW"]
[]
["2 - XLSB"]
[]
["3 - Other approaches"]
["OneDrive/Sharepoint (share a link, not a file), linking to data rather than importing it (Power Query)"]

{"sheet":"Q3","index":2,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,1,37,4]]}
["Setting default number formats for new workbooks"]
[]
[null,"Involves locating the Book and Sheet template files in the XLSTART folder (either in AppData or Program Files)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Take a backup copy of them first! Then in a blank workbook set your formats as required and go File > Save as. Select Excel template file type, set location of XLSTART folder and file name 'Book.xltx'"]
[null,"(may need to repeat for Sheet.xltx)"]
[]
["Forcing Excel to open workbook in cell A1"]
[]
[null,"Requires VBA:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The command"]
[null,"ActiveSheet.Range(\"A1\").Select"]
[null,"should be added to the relevant workbook object and the 'Open' procedure. This will then be executed on the active sheet every time the workbook is opened."]
[null,"NB this can be enhanced in various ways:"]
[null,"- to cycle through all sheets in a workbook and set the active cell as A1"]
[null,"    Dim ws As Worksheet\n    For Each ws In ThisWorkbook.Worksheets\n        ws.Activate\n        ws.Range(\"A1\").Select\n    Next ws"]
[null,"- to be added as a function to your personal workbook, allowing it to be added as a shortcut in the Quick Access Toolbar"]
[null,null,"Create and save all your macros in a single workbook - Microsoft Support"]
[null,null,"Assign a macro to a button - Microsoft Support"]