Forum Discussion
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 ex...
Hi,
Here are two tips that may help you:
#1 Use all processors for calculating
#2 Turn off Automatic Calculation
thanks, but i have already exhausted these options :-)