Rules & troubleshooting
One page for the rules that govern all three Name Conversion commands: when they’re available, what each scope covers, every reason something is skipped and how to resolve it, and a compact matrix that contrasts Flatten Names, Apply Names, and Restore at a glance.
Command availability
- Active license. Flatten Names and Apply Names are enabled while the license is Trial, Licensed, or Grace; they grey out when it’s inactive. There is no per-feature tier — both work in full during the trial.
- An open workbook. A conversion needs a workbook open. With none open, you’re prompted to “open a workbook first.”
- A snapshot, for Restore. Restore is additionally gated on a snapshot existing for the active workbook — so it’s only enabled after a Flatten/Apply has run this session and before you’ve cleanly restored.
Scope choices
Flatten and Apply both open the Choose Scope dialog. It remembers your last pick and starts on Entire workbook the first time.
| Scope | Covers | Visibility |
|---|---|---|
| Entire workbook | Every worksheet’s used range. | Hidden and very-hidden sheets are auto-skipped (and reported). |
| Active sheet | The active sheet’s used range. | Processed even if that sheet is hidden — the way to convert one hidden sheet on purpose. |
| Current selection | Exactly the cells you’ve selected. | Spans every sheet the selection touches; multi-area selections are unioned per sheet. |
Why a sheet or cell was skipped
Both commands are conservative: when a rewrite isn’t safe, the formula is left untouched and the reason is listed in the run summary. Here’s every reason and what to do about it.
| Reported as | Means | What to do |
|---|---|---|
| Worksheet is protected | The whole sheet was skipped (Flatten and Apply). | Unprotect the sheet and re-run, or convert it via Active sheet scope after unprotecting. |
| Sheet is hidden / very hidden | Auto-skipped under Entire workbook scope. | Switch to Active sheet scope to convert that sheet deliberately. |
| Formula too long | The rewritten formula would exceed Excel’s 8,192-character limit; the original was kept (nothing truncated). | Split or simplify the formula, or leave that cell in its current form. |
| Multi-area defined name (Apply) | A reference matched one area of a name covering several non-contiguous areas; substituting it would widen the formula’s meaning. | Leave it. If you truly want the name applied, redefine it as a single contiguous area. |
| External reference | A reference into another workbook — never converted by either command. | Expected. Names and references from other workbooks are out of scope by design. |
| Table / structured reference (Flatten) | A structured reference like Table1[Revenue] — not flattened. | Expected. Structured references are recognized and left alone. |
| Cell formula changed (Restore) | You (or another tool) edited that cell after the conversion; Restore won’t overwrite your edit. | Undo the edit and Restore again, or keep your edit — the snapshot stays until the restore is clean. |
| Sheet no longer in the workbook (Restore) | A snapshot cell’s sheet was renamed or deleted since the conversion. | Rename the sheet back to its original name, then Restore again. |
| Write rejected | Excel refused the formula write for that cell. | Check the cell/sheet state; the summary carries a plain-language detail for the specific cause. |
Two things that are not errors
- A no-op run. If nothing in scope matched — no defined names to flatten, or no references that exactly match an existing name — the run completes successfully with “Converted 0 formula(s)…” and offers no Restore (there was nothing to snapshot). That’s a clean result, not a failure.
- A collision warning (Apply). When more than one visible name targets the same cells, Apply still substitutes — picking by precedence (sheet-local over workbook-level; otherwise the first) — and warns you to verify in Name Manager if ambiguous. Confirm the chosen name is the one you meant. See Apply Names.
Common questions
| Symptom | Explanation |
|---|---|
| “A previous snapshot is still active” when I try to convert. | Only one conversion can be outstanding per workbook. Restore the last one (or close the workbook) before running another. |
| The Restore button is greyed out. | No snapshot for the active workbook — either nothing was converted this session, you already restored cleanly, or you reopened the workbook (snapshots don’t survive close). It’s also greyed out if the license is inactive. |
| Ctrl+Z didn’t bring my formulas back. | Expected — the add-in’s writes don’t feed Excel’s native undo. Use Restore, the supported recovery path. |
| All three buttons are greyed out. | The license is inactive. (If only Restore is greyed out, it’s the snapshot condition above.) With no workbook open you’ll be told to open one rather than the buttons disabling. |
| Some named formulas didn’t flatten. | They likely use external references, structured/table references, or names that resolve elsewhere — all left alone on purpose. See Flatten Names. |
Command matrix
How the three commands compare on the properties that matter for safety and recovery:
| Flatten Names | Apply Names | Restore | |
|---|---|---|---|
| Changes formula text? | Yes | Yes | Yes (writes originals back) |
| Changes the defined-name catalog? | No | No | No |
| Creates names? | No | No | No |
| Deletes names? | No | No | No |
| Changes cell values? | No (text only) | No (text only) | No (text only) |
| Uses Excel’s native undo (Ctrl+Z)? | No | No | No |
| Uses the in-memory snapshot? | Captures one | Captures one | Consumes one |
| Snapshot survives workbook close? | No | No | No |
| Works after a Save-As in the same session? | Yes (snapshot rekeyed) | Yes (snapshot rekeyed) | Yes |
The conversion is saved; the snapshot is not
The rewritten formulas from a Flatten or Apply are ordinary formula text — they’re saved with the workbook like any edit. What does not persist is the Restore snapshot: it lives in memory for the session only, so the ability to undo a conversion ends when you close the workbook, even though the conversion itself is saved.
Related
- Name Conversion overview — what the commands are for and the typical workflow.
- Flatten Names · Apply Names · Restore — the per-command details.
- Activation & licensing — license states and what enables features.