Performance Tools

Tools to fix slow or big Excel files.

Find slow formulas (Excel Profiler)

Find slow formulas

FormulaDesk has a profiler which times the calculation speeds of the cells in your file. This is a performance tools that shows you exactly where your spreadsheet is slow and gives you the information you need to make your spreadsheet faster.

It gives you the information you need to make your spreadsheet faster:

  • Calculation times.
  • Volatile cells - get a full list of all volatile cells and their calculation times.
  • Mini bar-charts make comparison easy.
  • Hovering over an address displays the underlying formula.

Find all volatile cells

The profiler can identify all volatile cells. These are cells that contain formulas that re-calculate every single time any cell is edited anywhere, and cause a rippling effect of re-calculations due to other cells referencing them, which in turn recalculate as well. Volatile cells can make your spreadsheets very slow because every little edit you make triggers possibly thousands or millions of re-calculations.

Examples of volatile formulas are: NOW()

Trim bloated files

Fix big Excel files

Excel can get bigger and bigger, for no apparent reason. This is often due to deleting many cells that previously had values. The problem is that their formatting remains, which takes up space and makes the file bigger. It often occurs when copy-pasting large numbers of cells from another file. The ‘Trim Bloated Workbook’ feature will fix this for you and trim down your Excel files, making them smaller.

The 'Trim Bloated Workbook' feature can find these blank rows and columns for you, and gives you the option to delete them too.

Fix the 'Too many different cell formats' error

If you receive a Too many different cell formats error in Excel, the 'Trim Bloated Workbook' features can tell you which custom styles in your spreadsheet are unused and can be deleted.