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 …