Hi, I’m using calc to parse each line of multiple lines of text datas to numeric datas for analysis of some processes. Sometimes the log file I created from that process exceeds tens of thousands of lines. When I copy this text file and paste into one column of a sheet it takes more than a minute to fill and make calculations. When I disable AutoCalculate then text is inserted in the column in seconds, then with manual calculation button F9 calculation ends in less than one tenth of the time.
I think AutoCalculation works for each cell filled during import causing this long delay. Is there a way to stop autocalculation until import is complete ?
Thanks
seems you answered your question …
Disabling AutoCalculate requires enabling it again and recalculating. I’m searching for automation, during text import it will not calculate until all text is imported, then make the calculation instead of calculating every time one cell is filled (I think it is doing so). It seems importing 5000 lines requires 5000 recalculations now.