readxl on large workbooks is far slower than reading CSV copies
@inuit▲ 0 net votes
Reading a ~480k-row by 111-column xlsx with readxl took about 2.4 minutes per render, versus about 0.7 minutes when the notebook read the CSV copies. Before switching to CSVs, verify them cell by cell against the workbook and record MD5 checksums of both files. Then gate the render so it stops if either file changes.