Formula Tables are usually parsed and executed using a VBA compatible interpreter engine. This approach offers several powerful tools - code editor, pseudo compiler,  run-time interpreter, debugger, etc. Formula Tables, however, are executed during the calculation and produce answers that AXIS is using as data to continue to run its logic. As a result, each Formula Table may be called millions of times at various points in the calculation procedure and can represent a significant portion of the total calculation time. The Formula Table accelerator can help reduce runtimes by compiling Formula Table VB code into machine level, optimized code.

How does it work?

If enabled - the Formula Table accelerator will be invoked when a Formula Table is run for the first time. It will try to translate it and, if no errors were found, create an executable assembly in memory. After the assembly is created, all subsequent calls to that Formula Table will be processed using the compiled assembly.