Use FastExcel V4 to Eliminate Calculation Bottlenecks

Once you have identified and prioritized the calculation bottlenecks you can set about eliminating and reducing them:

Slow Lookups and Matches

Use SpeedTools's advanced memory lookup technology to speed up recalculation of exact match lookups.

Sort the data and use SpeedTools super-fast sorted exact match lookup.

SpeedTools MEMMATCH, MEMLOOKUP, AVLOOKUP2 and AMATCH2 all use memory lookup and sorted exact match lookup

Use SpeedTools AVLOOKUP2 and AMATCH2 built-in exact match error handling

Handle multiple-condition lookups efficiently with SpeedTools AVLOOKUP2 and AMATCH2 rather than using slow array formulas or concatenation

Slow Array Formulas and SUMPRODUCT formulas

Use SpeedTools FILTER.IFS powerful and efficient multiple condition handling to replace slow SUMPRODUCT and array formulas.

Sort your data and use SpeedTools FILTER.IFS ability to exploit sorted data efficiently

Minimize the effective size of the ranges you are using with FastExcel Managers Dynamic Range Wizard (part of FastExcel V4 Name Manager Pro)

Eliminate Unnecessary Calculations

Use FastExcel V4 SpeedTools’ extended calculation options to control exactly which parts of your spreadsheets should be calculated.

Look for duplicated calculations in formulas or parts of formulas and break them out into a separate column so that they only have to be done once.

Slow VBA UDFs

Installing FastExcel V4 SpeedTools will bypass Excel’s VBE UDF refresh bug and speed up calculation when you have a large number of VBA UDFs.

SpeedTools powerful and extensive range of functions may be able to replace some of your VBA UDFs

Copyright © 2022 Decision Models Ltd.