{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PowerPage","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":27,"comments":1,"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":"PowerPage","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Workbook & \" (\" & sheetCount & \" sheets)\"","v":"_ix powerpage.xlsm (2 sheets)"},"Title in sheet",null,null,{"$f":"{\"\";\"bo.sinander@powerpage.se\"}","v":""},null,"Linked Files"]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:2)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:2))),\"\"),\"\")","v":"PowerPage"},null,{"$f":"ADDRESS(1,COLUMN(A1),4)","v":"A1"},null,"bo.sinander@powerpage.se",null,{"$f":"TRANSPOSE(links)","v":"C:\\Users\\su\\Documents\\1006_Excel\\index_sheet.xlsm"}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:3)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:3))),\"\"),\"\")","v":"Sheet1"},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":"Text in cell A1"}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:4)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:4))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:5)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:5))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:6)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:6))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:7)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:7))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:8)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:8))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""},null,null,"Ctrl+Shift+Q macro activates sheet 1"]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:9)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:9))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:10)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:10))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""},null,null,"Ctrl+PgDn to activate next sheet"]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:11)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:11))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""},null,null,"Ctrl+Shift+PgDn to select also next sheet"]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:12)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:12))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:13)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:13))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""},null,null,"Updates may lag. Press F9 to recalculate"]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:14)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:14))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:15)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:15))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:16)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:16))),\"\"),\"\")","v":""},{"$f":"IF($A:$A=\"\",\"\",INDIRECT(\"'\" & SUBSTITUTE(PowerPage!$A:$A,\"'\",\"''\") & \"'!\" & PowerPage!C$2))","v":""}]
[{"$f":"IFERROR(REPLACE(INDEX(sheetNames,ROWS($2:17)),1,FIND(\"]\",INDEX(sheetNames,ROWS($2:17))),\"\"),\"\")","v":""}]

{"sheet":"Sheet1","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Text in cell A1"]
[]
[]
[{"$f":"[1]PowerPage!$Y$15","v":0}]