Why Auditing Before Sending Matters
A spreadsheet that looks correct on screen can contain serious problems invisible to a casual glance. Formula errors in non-visible sheets. External links that break when the file moves computers. Hidden sheets with salary data, client lists, or confidential projections. Duplicate rows that inflate totals. Hardcoded assumptions nobody explained.
The recipient may notice none of these problems immediately — but they will eventually. And when they do, the damage to trust can far exceed the time saved by skipping the audit. This checklist covers everything worth checking before the file leaves your inbox.
Step 1: Scan for Formula Errors on All Sheets
Formula errors are the most visible sign of a broken workbook. Any cell showing #REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, or #NUM! immediately raises questions about the reliability of the entire file.
Do not just check the sheet you are currently viewing. Check every sheet in the workbook.
- Use Formulas > Error Checking > Error Checking to step through each error.
- Press Ctrl + ` (grave accent) to toggle formula view and scan for red error cells.
- Use the Spreadsheet Auditor to get a full report of errors across all sheets in seconds.
If errors are intentional — for example, a #N/A returned by a lookup that is expected to return no result — wrap them in IFERROR with a readable label like "Not found" so the recipient understands the result is expected, not a mistake.
Step 2: Review All Hidden Sheets
Hidden sheets are one of the most commonly overlooked risks when sharing Excel files. A workbook may have been built with hidden sheets for legitimate reasons: scratch calculations, lookup tables, backup data, version control rows. But some hidden sheets contain data that was never meant to leave the organization.
To see all hidden sheets: right-click any visible sheet tab and select Unhide. Review every hidden sheet before sharing the workbook. Ask yourself:
- Does this sheet contain salary, pricing, or margin data the recipient should not see?
- Does it reference client names or IDs that are confidential?
- Is the data still accurate, or is it outdated from a previous version?
If a hidden sheet contains sensitive data, delete it or move it to a separate file before sharing. If it contains calculations the recipient needs to verify, consider unhiding it and adding a note explaining its purpose.
Step 3: Check External Links and Named Ranges
External links reference other workbooks. When the recipient opens your file on a different computer, those links break — unless the referenced workbooks are also accessible from the same path.
To find external links: go to Data > Edit Links. Any links listed here will attempt to update when the file is opened. If the linked files are not available on the recipient's machine, the file will display prompts to update links, which can be confusing or cause errors.
Options for handling external links before sending:
- Break the links and replace them with hard-coded values if the linked data is final.
- Include the linked files in the email if the recipient needs them.
- Convert the workbook to PDF if the recipient only needs to read the output, not edit the formulas.
Named ranges that reference external files cause the same problem. Check Formulas > Name Manager and look for names that include a path like [OtherFile.xlsx].
Step 4: Review Hardcoded Values in Formulas
A hardcoded value is a number or text string typed directly inside a formula rather than referenced from a cell. For example: =B2*1.08 where 1.08 is a tax rate hidden inside the formula.
Hardcoded values are not always wrong, but they should be intentional and documented. If the recipient needs to change a tax rate, discount percentage, or exchange rate assumption, they need to know where those values live. A formula that multiplies by a hidden constant with no explanation looks unreliable.
The Spreadsheet Auditor can identify cells that contain hardcoded values within formulas across the entire workbook, making them easy to review before sharing. Consider moving key assumptions into a named input cell — like a "Assumptions" tab — so they are transparent to the recipient.
Step 5: Check for Duplicate Rows in Data Sheets
If the workbook contains exported or imported data, duplicate rows are a common problem. They inflate SUM totals, overstate COUNTIF results, and produce incorrect charts. A recipient who notices that your total is 10% higher than expected due to duplicate entries may question the entire analysis.
Before sending, check key data sheets for duplicates:
- Select the data range, go to Data > Remove Duplicates to get a count. Click Cancel — you do not need to remove them yet, just know whether they exist.
- Use the Duplicate Row Finder to preview which rows are duplicated before deciding whether to keep or remove them.
Remember that not all duplicates are errors. A customer may have ordered the same product twice. A code may legitimately appear across multiple records. Review flagged rows before deleting anything.
Step 6: Remove Blank Rows From Data Ranges
Blank rows inside data ranges can break filters, charts, PivotTables, and VLOOKUP references that the recipient may try to use. If the recipient pastes your data into another system, blank rows can cause import errors or split records.
Use Remove Blank Rows to clean data sheets before sending. If blank rows were intentional — for visual spacing — consider replacing them with row height adjustments or section headers rather than actual blank rows.
Step 7: Reduce File Size if Needed
Most email providers reject attachments over 25MB. If your workbook is larger than expected, common causes include:
- Formatting applied to entire columns or rows instead of just the data range.
- The used range extends far beyond the actual data (press Ctrl + End to check).
- High-resolution images or logos embedded in the workbook.
- Conditional formatting rules applied to full-column ranges.
- Old versions of sheets that were hidden but never deleted.
Use the Reduce Excel File Size tool for a fast before-and-after comparison. The full guide to reducing Excel file size covers each cause in detail.
Step 8: Check Confidential Data and Access
Before sending to external recipients, verify that the file does not contain:
- Employee salary, performance rating, or HR data.
- Customer PII (personally identifiable information) like full names, emails, or phone numbers that were included for lookup but not needed by the recipient.
- Margin, cost, or pricing data the recipient should not see.
- Internal comments or notes in cells that contain candid opinions or sensitive context.
If the recipient needs some of the data but not all, consider deleting the sensitive columns from a copy before sending, or creating a separate output tab that only contains the data the recipient needs.
Step 9: Save, Close, and Reopen Before Sending
After all cleanup steps, save the file, close it completely, and reopen it before attaching it to the email. This ensures:
- The file is not corrupted from partial saves.
- External link prompts appear (and you can verify you handled them).
- File size reflects all changes, including removed sheets and cleaned formatting.
- All sheets display correctly from the perspective of someone opening the file fresh.
Pre-Send Audit Checklist Summary
- Scan all sheets for formula errors using Formulas > Error Checking.
- Unhide all sheets and review content before sharing.
- Check Data > Edit Links and break or resolve external links.
- Review hardcoded values in formulas — document or externalize assumptions.
- Check data sheets for duplicate rows using the Duplicate Row Finder.
- Remove blank rows from data ranges.
- Check file size and reduce it if needed.
- Remove or redact confidential data the recipient should not see.
- Save, close, and reopen the file before attaching.
- Consider sending a PDF copy if the recipient only needs to read, not edit.
Frequently Asked Questions
How long should an Excel audit take before sending?
For a simple workbook with one or two sheets and straightforward formulas, a pre-send audit should take five to ten minutes. For a complex workbook with multiple sheets, pivot tables, and external links, allow thirty minutes. The Spreadsheet Auditor can compress the formula-checking portion to under a minute for most files.
Should I always send Excel files instead of PDFs?
Only send an editable Excel file if the recipient actually needs to interact with the formulas, update inputs, or copy the data. If the recipient only needs to read the output, a PDF is safer — it prevents accidental edits, is smaller, and does not expose underlying formulas or hidden sheets.
How do I find comments and notes in Excel before sharing?
Go to Review > Show All Comments to display all comment bubbles at once. Review each one for sensitive content before sharing. In newer versions of Excel, check both Comments and Notes separately, as they are stored differently.