Calculation Performance of iterative what-if Data Tables is unnecessarily slow. The reasons seem to be (in priority sequence):
- each iteration is using single-threaded recalculation rather than multi-threaded
- the overhead for the whole table calculation looks larger than it should be
- the process starts with a recalc, then does each iteration, then ends with a recalc: the first recalc is unnecessary
- if the values to be used in one of the iterations are the same as the start values the recalc for that set of values could be skipped76 votes
Many thanks to Charles for taking the time to analyze this in such detail and start the discussion about improving the efficiency of data tables. Please vote for this issue if it’s important to you so we can prioritize it appropriately.
Steve (MS Excel)
- Don't see your idea?