Forum Discussion
Deleted
Oct 13, 2017Not applicable
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...
Deleted
Nov 01, 2017Not applicable
thanks, but i have already exhausted these options :-)
SergeiBaklan
Nov 01, 2017Diamond Contributor
10K rows shall not be an issue, if only array-like formulas and VLLOKUPs. Just in case here are https://msdn.microsoft.com/en-us/library/office/mt709003.aspx some tips