excel slow on large number of entries with calculations
Hi Experts this is an issue that refuses to go away, i noticed that with an excel sheet with large number of rows, usually more than 10K rows, along with a simple calculation like countif, causes excel to stop respinding showing % counter progressing slow and even slows down the PC. i have an I7 CPU, 16GB RAM and 256 HD SSD so i think its quite a powerful machine, yet still slow. is there a way to wrokaround this? access or and sql db is fairly limitied as i will have to spend a lot of time learning sql queris, and sometimes its gust to much, to get similar results to index, Xlookup and other function in excel. please help