Skip to main content

Cache Optimizer

The Cache Optimizer provides recommendations to improve the performance of your Add‑in reports and reduce Excel workbook refresh times. It analyzes your references and generated NecAccess formulas, then produces a report showing how to optimize them.

How the Cache Optimizer works​

StageHow it works
Analyze Excel workbook contentPerforms a detailed scan of formulas and references used in the Excel workbook.
Generate optimization suggestionsProvides actionable recommendations to improve performance and efficiency.

Perform an analysis​

Before running the optimizer, ensure you are connected to your Central Point and that the Excel workbook you want to analyze is open. The Cache Optimizer generates recommendations only when the Excel 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 the optimization report, then select OK. The name must be different from any existing sheet.
  3. Allow the Cache Optimizer to begin analyzing the Excel workbook. A progress window appears with two options:
    • Stop analysis – Stop the process immediately. A report is created only for references already analyzed. If none are completed, no report is generated.
    • Skip reference – Skip the current reference. If all references are skipped, no report is generated.
  4. When the analysis is complete, a new sheet containing the report is added to the Excel workbook.

note

Analysis time increases with Excel workbook size, especially when many references or large data models are involved.

Apply recommendations​

Once the optimization report is generated, review and apply the suggested changes.

  • Remove a dimension – Highlighted in red.
  • Add a dimension – Highlighted in red.
  • Leave a dimension unchanged – Highlighted in green.

Apply changes​

  1. In the Change to apply column, select a cell and choose a behavior from the dropdown menu.
  2. When reeady, select Apply changes and recalculate at the top of the report.
    Important: This button works only if your UI language matches the language used when the report was generated.
  3. Track progress in the Change to apply column. When all cells turn green, the changes have been applied and appear in the Reference Configurator.