Cache Results

Use this command to toggle the value of the current function's cacheresults attribute. This attribute determines whether code is generated to cache the results of each calculation, so that they will be available immediately if the function is called again with the same arguments. Since Excel often recalculates cells unnecessarily, the cache can improve performance markedly.