In December, Google released new Sheets, saying they are faster and better than the old – including working offline. I’ve made a couple of tests to compare the old and the new – a simple operation – writing data.
In each case I’m doing 2 tests
- Writing data cell by cell to a sheet
- Writing data in a single operation to a sheet
This shows the average run time across each of the 3 variations
So we see that that writing values all at once, as opposed to cell by cell is still about 5 times as fast, and that new sheets is indeed 2-3 times as fast as old sheets for this kind of test. Of course, VBA, since it is entirely local is much faster than either to perform equivalent operations