We work on a huge excel file. it contains a sheet setting 22000 lines
We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram.
- We have disabled the automatic computation of the file
- the file contains sometimes 13 columns and 15000+ lines
- there is no macro
- there is no link to external files
- the sheet can't be further split; one sheet contains most formulas and one sheet contains static data + 1 single column computing an id
We wait up to 10 minutes when a copy/paste is made We wait up to 5 minutes when a formula has been changed
Same order of magnitude on Mac and Windows machines.
Do you know any best practice to deal with such size besides developing a tool?