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
- The grade: A to E. It is never better than C while anything is a likely main cause.
- Where the time goes: a bar per sheet. It is an estimate from a cost model, not a stopwatch, and it says so.
- The findings: ranked by estimated cost, each with where it is, why it matters and what to do.
- The fixes: four safe ones, each previewed first. Undo is free in every tier.
- External links are not covered here; the External Link and Dependency Mapper does that.
Three steps
- Install. Get it from Microsoft Marketplace, or from Home › Add-ins › Get Add-ins in Excel and search for the name.
- Check. Open a workbook, then Home › Workbook speed › Check speed, and press Check this sheet.
- 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-01 | Formatting dragged 1,000 or more rows (or 50 columns) past the last value, so the used range is far bigger than the data |
WS-02 | Five million or more cells inside the used ranges |
WS-03 | NOW, TODAY, RAND, RANDBETWEEN, RANDARRAY, OFFSET, INDIRECT, CELL and INFO, and every formula downstream of them |
WS-04 | Manual calculation (stale results), or Automatic with thousands of volatile cells |
WS-05 | Iteration switched on |
WS-08 | VLOOKUP, XLOOKUP, SUMIFS and friends over whole columns of a sheet whose used range is 10,000 rows or more |
WS-09 | The same lookup copied down 100 rows or more |
WS-10 | Ten or more identical rule fragments, or whole-column custom rules |
WS-11 | Ten or more calls to VBA or add-in functions |
WS-12 | Running totals 5,000 or more cells deep |
WS-13 | Validation over 100,000 or more cells |
WS-14 | Charts, pivot tables and shapes; sixty or more sheets |
WS-15 | Five hundred or more formulas, and how few patterns they share |
WS-16 | A thousand or more custom cell styles |
WS-17 | Five 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
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.