XLL+ Class Library (7.0)

Function.CacheResults

Specifies whether the function's results should be cached, to improve performance of expensive calculations.

Remarks

If this property is set to true, then the function's result will be stored in an application-level cache. Each time the function is called, the cache is searched for an identical set of inputs. If they are found, then the result is returned from the cache and the implementation function is not called. This can result in a considerable performance improvement.

The default value for the property is false.

Requirements

An application-level results cache must exist in order for this feature to work. Create a results cache when creating the add-in project using the AppWizard.

See Also

Function Model | Function Properties | Results cache