Forum Discussion
excel slow on large number of entries with calculations
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 :-)
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
Hi Sergey
not sure how to formulate the question....
for example the following countif: =countif($a$2:$A$50000,a2),is calculation time linear? e.g. number of rows multiplied by the sub calculations where each time you have to go over the whole array to count each entry?
is the time doubled if i do countifS for 2 columns?
is the calculation time linear until some point and than in becomes exponential of sort of simply take so much time that it looks like it?
and for any case, is there a number from which it becomes not efficient to run this type of calculation?
