Hidden sheets, very-hidden sheets, and what Excel won't show you
A spreadsheet you're about to share can contain entire sheets you can't see, formulas pointing at internal data, and identity metadata. Where Excel hides data and how to audit a workbook before it leaves your hands.
Three visibility states, one of which Excel hides from you
Every sheet in an Excel workbook has one of three visibility states: visible, hidden, or very hidden. Hidden sheets can be restored by any user via right-click → Unhide. Very-hidden sheets are different: they don't appear in the Unhide dialog at all. The state can normally only be changed through the VBA editor or by editing the file's XML — which means a typical recipient has no idea the sheet exists, and neither does a typical sender.
Very-hidden sheets are legitimately used by template authors to stash lookup tables and configuration. They're also where salary tables, customer lists, and 'working' data quietly live in files that get forwarded for years.
Beyond sheets: the other hiding places
Sheet visibility is only the most famous hiding spot. A workbook audit needs to cover more:
- Hidden rows and columns — data collapsed out of view but fully present in the file
- Defined names — named ranges that can reference internal data and reveal structure ('Q3_layoffs_list' is a real kind of leak)
- Comments and notes — often containing discussion, author names, and context that was never meant to travel
- Formulas — a visible cell's formula can reference a hidden sheet, proving its existence and sometimes caching its values
- Document properties — author, last-modified-by, company, and revision metadata
- Pivot caches — pivot tables keep an internal copy of their source data; a pivot summary built from a detailed sheet can carry the detail with it even after the source sheet is deleted
Why 'delete the sheet and save' isn't a full answer
An .xlsx file is a ZIP package of XML parts, and edits don't always scrub every part. Shared strings can retain text from deleted cells, pivot caches can retain source rows, and properties keep identity fields. Editing in place means trusting that every one of those parts was rewritten correctly.
The robust pattern for sharing is a values-only rebuild: create a brand-new workbook and copy in only the visible values you actually intend to share. Formulas, comments, links, names, macros, caches, and properties never existed in the new file, so there's nothing to scrub.
How to do this locally
Our Excel Hidden Data Inspector parses the workbook package in your browser — nothing uploads — and inventories sheet visibility (including very hidden), hidden rows and columns, defined names, hyperlink targets, comments, and document properties. You can preview any sheet, hidden or not, in a read-only grid; macros are detected and flagged but never executed.
When you've seen what's inside, the Clean Excel Copy tool builds a fresh values-only workbook from the sheets you select — hidden sheets excluded by default — and then reparses its own output to verify it contains no formulas, comments, links, names, or properties. For metadata alone, the Excel Metadata Remover strips identity fields and verifies the result. The verified output is the file you share; the original stays untouched on your machine.