2 ms·
I taught an engineer how to do 2D iterative scenarios with TABLE(), and his XLS files began taking 30+ minutes to open. Every XLS ended with "-DANGERTABLES.xls"
by SavantIdiot 6y ago
I taught an engineer how to do 2D iterative scenarios with TABLE(), and his XLS files began taking 30+ minutes to open. Every XLS ended with "-DANGERTABLES.xls" to remind us not to accidentally click it and kill our machines. [For those who don't know, it's basically a way to reduce a massively interconnected spreadsheet (dozens of sheets) as f(x,y)=z, and then make hundreds of tables built with that function. Insanely powerful, but causes spreadsheets to grind to halt every time you touch a cell (unless you turn off auto computation).]