Workbook review checklist before sending an Excel file

Scanning for #N/A, #REF!, broken external links, and hidden sheets before emailing a client or board workbook.
Watch alongside this article
Public YouTube resources matched to this article's topic, functions, and practice goal.

Excel Real Time Co-authoring - Track Changes, Mentions, Chat and More!
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)
Collaborate on Excel Workbooks at the Same Time with Co Authoring
Microsoft Support
Open on YouTube (opens in a new tab)
Most embarrassing spreadsheet moments are not calculation errors. They are a
filter nobody cleared, a hidden sheet with last year’s salary figures, or a
formula that worked perfectly on your machine and shows #REF! on theirs.
Ten minutes before you hit send catches nearly all of it. Here is the order worth doing it in — cheapest and most common failures first.
1. Clear filters and check the row count
This is the single most common error in shared workbooks, and the most invisible, because a filtered sheet looks like a complete sheet.
Press Ctrl+End on each data sheet to see where the data actually stops, then glance at the status bar — Excel shows “X of Y records found” when a filter is active, and the row numbers turn blue. Data → Clear removes all filters on the active sheet at once.
If a filter is intentional — a report deliberately showing only open items — say so on the sheet in a cell, not in the covering email. The email gets forwarded without its body.
Check sort state too. A list sorted by a column you were investigating is a list that no longer matches the order the recipient expects.
2. Unhide everything, then decide what to re-hide
Right-click any sheet tab → Unhide shows hidden sheets. But that dialog does not show very hidden sheets, which are set through VBA and are invisible to it. If the file came from elsewhere, press Alt+F11 and look at the Project pane — every sheet in the workbook is listed there regardless of visibility.
Then hidden rows and columns. Select all (Ctrl+A), then Home → Format → Hide & Unhide → Unhide Rows, and again for columns. Grouped sections collapse rather than hide; expand them with the outline buttons in the margin.
Now look at what you have revealed. Working notes, an old scenario, salary data, a client’s figures from the last engagement — delete anything the recipient should not receive. Hiding it is not removing it. Anyone can unhide it in two clicks, and anyone who opens the file in a text editor or a different tool sees it whether they unhide it or not.
3. Check external links
Data → Queries & Connections → Edit Links (or Data → Edit Links in older versions) lists every workbook this file depends on. If the button is greyed out, there are none — good.
If there are links, the question is whether the recipient can reach those files.
A link to C:\Users\you\Documents\assumptions.xlsx will not resolve on their
machine, and they will be greeted by an update prompt they do not understand.
Either Break Link to freeze the values — the usual right answer for a report — or make sure the source lives somewhere shared and the link points there.
Formulas referencing another file show the full path in square brackets when that
file is closed, so a quick Ctrl+F for .xls across the workbook finds them
too, including the ones hiding inside defined names.
4. Hunt for errors and the things pretending not to be errors
Press F5 → Special → Formulas → Errors to select every error cell in the sheet at once. Repeat per sheet.
Then look for the opposite problem: errors that have been wrapped in IFERROR
and are now invisible. IFERROR(VLOOKUP(...),"") turns a genuine lookup failure
into a blank cell that sums as zero. That is fine when a blank is the right
answer and dangerous when it isn’t. Search the workbook for IFERROR and satisfy
yourself that each one is suppressing an error you expected rather than hiding
one you didn’t.
Open Name Manager (Ctrl+F3) and sort by Value. Names showing #REF! are
broken and will produce errors for the recipient even if nothing on screen looks
wrong today. The wider version of this pass is the
formula audit checklist.
5. Check the file is calculating
If anyone has ever set calculation to Manual in this workbook, the setting is saved in the file and travels with it. Formulas → Calculation Options should read Automatic. Press F9 before you look at any number you are about to send.
This matters more than it sounds: a workbook sent in Manual mode shows the recipient stale values with no warning at all.
6. Reset the view
Small things, but they are what the recipient sees first:
- Put the cursor in A1 on every sheet before saving. Excel reopens a file exactly where you left it, so a workbook saved at row 4,000 opens there.
- Select the first sheet as the active one.
- Set the zoom consistently — a sheet saved at 70% and another at 130% feels broken.
- Freeze panes on long lists so headers stay visible.
- Collapse grouped rows to the summary level you want them to start at.
7. Strip personal metadata
File → Info → Check for Issues → Inspect Document finds author names, comments, tracked changes, hidden sheets, and custom document properties, and offers to remove them.
Two cautions. Run it on a copy, because the removal is not undoable. And read the list before clicking Remove All — it will happily strip headers and footers you wanted to keep.
Threaded comments and notes deserve a separate look: Review → Show Comments and Review → Notes → Show All Notes. An internal aside left in a cell comment is a classic.
8. Protect the right areas — and know what that means
If the file is a template or a data-collection form, unlock the input cells (Format Cells → Protection → untick Locked) and then protect the sheet. Everything is locked by default, so protecting without unlocking inputs first produces a workbook nobody can type in.
Be clear about what sheet protection is: it stops accidents, not people. It is not encryption and not a security control. Anything genuinely confidential should not be in the file you are sending. If the whole file needs protecting, File → Info → Protect Workbook → Encrypt with Password is the real mechanism — and send the password through a different channel.
9. Shrink the file if it has grown strange
A workbook that is 40 MB for 2,000 rows usually has one of three things: a used range stretching to row 1,048,576 (select the first empty row, Ctrl+Shift+End, delete rows, save, reopen), cached pivot data (PivotTable Options → Data → untick Save source data with file), or hundreds of stray objects (F5 → Special → Objects will select them so you can see what they are).
Large files get stripped by mail servers, and the recipient never tells you — they just never reply.
10. Send a PDF alongside it when the layout matters
If the file is for reading rather than editing, attach a PDF too. It preserves the view you intended, opens on a phone, and cannot be accidentally edited into a different number. Getting the layout right first is its own job — preparing an Excel dashboard for PDF export covers print areas, scaling, and the headers that give a forwarded PDF its context.
The last check: open it as the recipient
Close the file. Reopen it. Spend thirty seconds looking at it as though you had never seen it before.
Can you tell what the file is for? Can you find the main number? Do you know what you are meant to do with it? If not, add a short notes block at the top of the first sheet saying what the file is, what period it covers, where to type, and who to ask. Four sentences there save more email than any other part of this list.
FREE EXCEL UPDATES
Get practical Excel tips in your inbox
New tutorials, tools, templates, and worked examples a few times a month. Unsubscribe anytime.
Go deeper with this skill
Prepare a workbook so other people can review it without breaking formulas or guessing what changed. For this article, the goal is to practice: The ten-minute pass before you attach a workbook — filters, hidden sheets, broken links, errors, personal metadata, cached pivot data, and the recipient test that catches the rest.
Practice workbook setup
Use a copy of a workbook that contains inputs, formulas, and at least one summary sheet.
Practice workflow
- Mark input cells, formula cells, and output cells with a consistent visual system.
- Add comments or notes only where a decision needs context.
- Protect formula-heavy areas after confirming reviewers can still edit the intended cells.
- Save a dated review copy before sending or sharing the workbook.
Quality checks
- Reviewers know where to enter feedback or new values.
- Important formulas are protected from accidental edits.
- The workbook has a clear version or date marker.
Common mistakes
- Sending a workbook with hidden sheets or stale filters still active.
- Using comments as a replacement for clear labels.
- Sharing before checking links, formulas, and external references.
Next actions
- Create a review checklist tab and reuse it for future workbooks.
- Test the file by opening it from the same link or attachment a reviewer will use.
Formula focus: test IFERROR() with normal rows, blank inputs, and at least one edge case.






