AppGarden Workbook Speed Checker logo AppGarden

Workbook Speed Checker

AppGarden Workbook Speed Checker logo

Workbook Speed Checker

Find what is making an Excel workbook slow. It grades the workbook A to E, shows where the time goes sheet by sheet, and lists the causes in order of what each probably costs. Free to check the sheet you are on.

Install: Available on Microsoft Marketplace. It is a task-pane add-in for Excel; verification on each platform (Windows, Mac and the web) is still in progress. It is not offered in the Excel mobile apps. This page is the support and documentation page the listing points to.

Before

It just feels slow

Every edit pauses. The file takes a minute to open. In an example like this one, there might be thousands of volatile cells, a lookup over whole columns and a used range running far past the data, and nothing says which matters.

After

Ranked

Findings ordered by estimated cost, each one named, located and explained. Click to jump to the cell. A preview before any fix, and Undo is always there.

The one to know about

Excel recalculates a lot more than people expect. A single NOW, OFFSET or INDIRECT is “volatile”: it recalculates on every change anywhere in the workbook, and so does everything that depends on it. A used range that runs to row 300,000 because of stray formatting makes every whole-column reference walk all of it. Finding which of these is in your workbook, and how much each costs, is the reason this add-in exists.

What it covers

Three steps

  1. Install. Get it from Microsoft Marketplace, or from Home › Add-ins › Get Add-ins in Excel and search for the name.
  2. Check. Open a workbook, then Home › Workbook speed › Check speed, and press Check this sheet.
  3. Fix. Open a finding, press Preview fix to see the exact change, then apply it. Press Undo to put it back.

What it checks

Every finding carries a rule code, so a report you read again in six months still says which check produced which line.

WS-01Formatting dragged 1,000 or more rows (or 50 columns) past the last value, so the used range is far bigger than the data
WS-02Five million or more cells inside the used ranges
WS-03NOW, TODAY, RAND, RANDBETWEEN, RANDARRAY, OFFSET, INDIRECT, CELL and INFO, and every formula downstream of them
WS-04Manual calculation (stale results), or Automatic with thousands of volatile cells
WS-05Iteration switched on
WS-08VLOOKUP, XLOOKUP, SUMIFS and friends over whole columns of a sheet whose used range is 10,000 rows or more
WS-09The same lookup copied down 100 rows or more
WS-10Ten or more identical rule fragments, or whole-column custom rules
WS-11Ten or more calls to VBA or add-in functions
WS-12Running totals 5,000 or more cells deep
WS-13Validation over 100,000 or more cells
WS-14Charts, pivot tables and shapes; sixty or more sheets
WS-15Five hundred or more formulas, and how few patterns they share
WS-16A thousand or more custom cell styles
WS-17Five hundred or more names, or ten or more pointing at #REF!

See the guide for what each rule means and what to do about it.

Free vs Pro

Free

£0

  • Check the sheet you are on, with the grade, the bars and every explanation
  • A preview of every fix
  • Undo — always, in every tier

Pro

£29 per year, or £4 a month

  • Everything in Free
  • Check every sheet at once
  • Apply the fixes: clear excess formatting, freeze volatile cells, set Automatic calculation, merge conditional-format rules
  • An exportable report, downloaded as CSV or Markdown
  • 3 activations on one key
  • 30-day full refund

Prices and checkout

Your data

Your workbook content never leaves your machine. The rules run in the task pane, on your computer, and the scan reads formulas only. The only network traffic this add-in makes is to the licence server, and only a licence key, an anonymous install id and which host this is ever cross it. Privacy notice.

FAQ

Does it measure how long my workbook takes? Not yet. The grade and the bars are estimated from what is in the workbook, and every screen labels them that way. A measured before and after is planned only if it proves reliable.

Does my data leave my machine? No. Scanning and fixing both happen in the task pane, against the open workbook.

What if I want to undo a fix? Every fix saves what it is about to change inside the workbook first. Press Undo in the pane to put it back, in any tier, at any time.

Why does it not fix everything? A wrong fix is worse than a wrong finding. It only offers a fix when it can preview the exact change, check that nothing depends on what it is about to touch, and undo it. The rest it explains.

Will it change my formulas? Only the volatile NOW, TODAY and RAND-family cells, only when you press the button, and only after showing you which cells. OFFSET and INDIRECT cells are never frozen.

Also for Google Sheets™: Sheet Speed Checker. The same licence key works in Excel™ and Google Sheets™.

Support

Email support@appgarden.co.uk. Say which finding looked wrong and, if you can share it, a copy of the workbook with the problem (names and amounts redacted) — read the privacy notice first.