Skip to main content

Cache Optimizer

The Cache Optimizer feature provides recommendations on how to enhance the performance of your Add-in reports and minimize workbook refresh times. It analyzes your references and generated NecAccess formulas, then produces a report that outlines how they can be improved.

The Cache Optimizer works in two stages:

StageDescription
Analyze workbook contentPerforms a detailed analysis of formulas and references used in the workbook.
Generate optimization suggestionsProvides performance recommendations that you can apply directly to improve efficiency.

Perform an analysis​

Before starting, ensure you are connected to your Central Point and that the workbook you want to analyze is open. The Cache Optimizer produces recommendations only if the workbook contains Excel Add-in references and formulas.

Run the Cache Optimizer​

  1. In the Add-ins tab, select Cache Optimizer.
  2. Enter a sheet name for your optimization report, then click OK. The name must be different from an existing sheet.
  3. The cache optimizer begins analyzing the workbook. A progress window appears:
    • Stop analysis – Stop the analysis immediately. A report is generated only for references already analyzed. If none are completed, no report is created.
    • Skip reference – Skip the current reference. If all are skipped, no report is created.
  4. When completed, a new sheet containing the report is added to the workbook.
note

Analysis time varies depending on the workbook size.

Applying recommendations​

Once the optimization report is available, you can choose to apply the suggested changes to your workbook.

  1. Review recommended changes:
    • Remove a dimension – Highlighted in red.
    • Add a dimension – Highlighted in red.
    • Leave a dimension unchanged – Highlighted in green.
  2. To adjust a recommendation, select a cell in the Change to apply column and choose a behaviour from the dropdown menu.
  3. When reeady, click Apply changes and recalculate at the top of the report.
    Important: This button works only if your UI language matches the one used when the report was generated.
  4. Track progress in the Change to apply column. When all cells turn green, the changes are applied and appear in the Reference Configurator.