Saving the file in binary format may reduce memory requirements, or at least the processing load when saving the file or the auto backups. Save the file as an Excel binary file (*.xlsb) Not sure if it would really speed things up, but its worth a try.ģ. Try array formula, as Excel would do calculations in bulkĪlternatively you can try to use array formula per column =(B2:B1000 - $I2:$I1000) and CTRL+SHFT+ENTER while selecting the whole output column L2:L1000. What if you put your zero'ing table in a new sheet/workbook, and putting calculations on manual? Prep the formulae in the new sheet:Ĭopy and paste across, then press calculate.Ģ. Calculate from other sheet / workbook, with calculations on manual It could be that the amount of memory required simply exceeds what your computer has available.
However it seems your problem is more related to the size of the data, and Excel crashing during a simple subtraction calculation.
Simple cell by cell subtraction with the delta column vector "$"-locked would work for normal size data sets e.g.
0 kommentar(er)
