If an Excel file is too large to attach, first check the size limit imposed by your email provider; if the workbook exceeds it, reduce the file or upload it to OneDrive or another approved file-sharing service and email a sharing link. A workbook can be large because of unnecessary formatting, images, data, or embedded objects, but sometimes the file is fine and only the email attachment limit is the problem.
Why an Excel workbook will not attach
Email services limit the total size of a message, not just the visible size of the spreadsheet. The limit varies by provider, account type, and workplace settings. As a result, a file that attaches successfully in one email account may be rejected by another. Some services also count the message’s encoding overhead: attachments can take roughly one-third more space during transmission, although providers calculate limits differently. Leave a margin rather than aiming exactly at a stated maximum.
There are two different problems to separate:
- Attachment limit: The workbook is a reasonable size, but it is over your email service’s limit. Sharing a link is usually the simplest fix.
- Unusually large workbook: The file itself is much larger than its contents seem to warrant. Removing excess data or saving in a suitable format may help.
- Upload or send failure: A slow connection, security policy, or temporary service issue may be involved. Check the error message and try a link or a smaller test file.
Excel worksheets can hold up to 1,048,576 rows and 16,384 columns, but that does not mean a workbook near those limits will perform well. Workbook size and speed also depend on formulas, formatting, images, pivot tables, the Data Model, and the computer’s available resources.
Check the file size and find the cause
In Windows File Explorer, locate the workbook and check its Size in the file details or Properties. In Excel, use File > Open to find and open it, then consider whether the displayed file size matches what you expect. A workbook with a few tables might still be large if it contains high-resolution pictures, many formatted blank cells, or copied data on hidden sheets.
To check how far Excel thinks the used area extends, open the relevant worksheet and press Ctrl+End on Windows. Excel moves to the last cell it considers used. If your real data ends near row 500 but this takes you to row 800,000, excess formatting or other content may be inflating the worksheet. This check is a clue, not a full diagnosis: a workbook may also contain other sheets, images, pivot caches, or embedded files.
Before removing anything, make a copy of the workbook. Then review each sheet, including hidden sheets, and check for objects such as pictures, charts, or controls. Do not delete data just because it appears blank; formulas, named ranges, or processes may rely on it.
Reduce workbook size without losing needed content
Start with changes that are easy to reverse and unlikely to alter the results. Save a separate copy before cleanup, especially if the workbook is shared or used for reporting. Useful checks include:
- Remove unused formatting: Select genuinely unused rows or columns, then use Home > Editing > Clear > Clear Formats. Avoid clearing formatting from cells that contain data or are part of a template. Save, close, and reopen the file, then check its size again.
- Delete unnecessary data: Remove duplicate exports, obsolete sheets, and old records only when they are not needed for calculations, audit history, or other users.
- Resize pictures: Select a picture and use Picture Format > Compress Pictures on Windows. The available options can vary with the Office version. Compressing can reduce image quality, so preserve the original if detail matters.
- Review embedded objects: Files inserted into a workbook, such as documents or other workbooks, can add substantial size. Remove them only if recipients do not need them.
- Check pivot tables and imported data: Pivot tables, imported source data, and the Data Model can contribute to workbook size. Do not remove a cache or source table without checking whether users need to refresh the report or inspect its underlying data.
Excel does not have one cleanup button that safely removes every source of bloat. For example, deleting a worksheet may shrink a file but also remove formulas or reporting context. If the file is unexpectedly huge, compare a copy after each change so you can identify which action made a difference.
Choose the right Excel file format
The standard .xlsx format is a compressed, XML-based workbook format. It is suitable for most workbooks, but saving an already compressed file inside a ZIP archive often produces little further reduction. Renaming an .xlsx file to .zip is not a safe way to shrink or send it.
For a workbook that does not need features incompatible with it, Excel Binary Workbook (.xlsb) may produce a smaller file and can be worth comparing. In Excel for Microsoft 365 on Windows, use File > Save As, choose a location, and select Excel Binary Workbook (*.xlsb) in the file type list. Check that formulas, connections, pivot tables, and any macros still work as expected, and confirm that recipients can use the format. Some organizations’ tools or workflows expect .xlsx.
Do not save a macro-enabled workbook as .xlsx if you need to preserve its VBA macros: .xlsx does not store VBA code. Use the appropriate macro-enabled format, such as .xlsm, or consider .xlsb where compatible. A CSV file can be much smaller for a single plain data table, but it does not preserve multiple sheets, formulas as formulas, formatting, charts, or workbook features. It is a data export, not a smaller equivalent of a full Excel workbook.
Use a cloud link instead of an attachment
When a workbook is too large for email, sharing a link is often better than repeatedly trying to compress it. Upload or save the workbook to OneDrive, then use its Share option to create a link or invite specific people. In many Microsoft 365 environments, you can also use Share from Excel. The recipient can access the shared copy without every email carrying another full attachment.
Choose access deliberately. A link limited to named people is generally more controlled than a link that anyone can use, but your organization may restrict which options are available. Check whether recipients can view or edit, whether they need a Microsoft account, and whether the link will expire or be blocked by policy. Do not place sensitive data in a broadly accessible link just to bypass an email limit.
OneDrive and other services can have their own storage, upload, or organizational limits. A recipient may also lack permission or be unable to download from a particular service. If the audience is outside your organization, confirm that external sharing is allowed before relying on a link. On Mac, Excel’s sharing workflow is similar in purpose, though the interface and available commands can differ by release; sharing through OneDrive in a browser is another option.
When splitting or exporting makes sense
If recipients need only part of a workbook, send a copy containing only the relevant sheets or data, provided that removing the rest will not break required formulas or context. For a large table, you might filter it to a requested date range and save the selected records in a separate workbook. Keep the full original unchanged, and clearly label the extract so nobody mistakes it for the complete dataset.
Splitting a workbook by month, department, or other meaningful category can help when recipients need separate portions. It also creates risks: recipients may work from different versions, miss a section, or combine overlapping records incorrectly. State the contents and date range of each file, and keep a clear source copy. For a single flat table, CSV may suit a data-processing workflow, but explain that it does not retain the workbook’s other sheets and presentation features.
Common fixes that do not solve the problem
Compressing an .xlsx file into a ZIP archive is often ineffective because .xlsx is already compressed. The ZIP can also make it less convenient for a recipient who expects to open the workbook directly. Password-protecting or encrypting a workbook is not a size-reduction method; encryption may make compression less effective, and recipients will need the password through a safe channel.
Changing the file extension manually does not convert the workbook. Use Excel’s Save As command to choose a real format. Likewise, deleting random rows or setting calculation to manual may change results or behavior without meaningfully reducing file size. If Excel reports that the workbook is corrupt, or the size is implausible, make a copy and use Excel’s repair options or ask your organization’s support team rather than repeatedly overwriting the only version.
Protect the workbook and avoid version confusion
Email attachments create separate copies. Once several people download and edit them, it can be unclear which copy is current. A shared cloud workbook can make collaboration easier, but only if permissions and editing expectations are clear. Tell recipients whether they should edit the shared original, download a read-only copy, or return a separate version.
Before sharing, review hidden sheets, comments, document properties, and data that should not go to the recipient. A reduced copy is not automatically a safe copy: hidden or supporting data may remain. Use your organization’s approved storage and sharing tools for confidential, personal, or regulated information, and follow its retention and access rules.
Frequently Asked Questions
What is the maximum Excel file size I can email?
Email providers and work accounts set different message limits, and the limit may apply to the whole message rather than the workbook alone. Check your provider’s current attachment guidance or ask your administrator; leave room for message overhead.
Will zipping an Excel file make it small enough to send?
Usually not by much for an .xlsx workbook, because that format is already compressed. A ZIP archive can help with some other file types, but it is rarely the best fix for a large modern Excel workbook.
Is XLSB smaller than XLSX?
It can be, but the difference depends on the workbook and its features. Save a separate .xlsb copy, compare its size, and verify compatibility before sending it.
Can I email an Excel file through OneDrive?
Rather than attaching it, upload or save it to OneDrive and share a link with suitable permissions. The recipient’s access depends on the link settings and any account or organization restrictions.
Why is my Excel file huge when it has little data?
Possible causes include formatting applied far beyond the data, large images, embedded files, hidden content, pivot caches, or a Data Model. Check the used range with Ctrl+End on Windows and inspect every sheet and object before cleaning up a copy.
Related
- Excel DOS Keyboard Shortcuts: What Actually Works
- Excel Direct Access vs Link: What’s the Difference?
- Excel Desktop Keyboard Shortcuts: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Solver Binary Constraint: How to Set It UpYes. In Excel Solver, add a constraint that sets the decision-variable cells to bin (binary); Solver will then…
- XLOOKUP in Google Sheets: Formula, Examples & TipsGoogle Sheets has an XLOOKUP function for finding a value in one range and returning the corresponding value…
- How to Count Dropdown Values in Google SheetsTo count a particular dropdown choice in Google Sheets, use COUNTIF: if the dropdown answers are in B2:B100,…
- Excel Workbook Not Opening? Causes and Fixes for WindowsIf an Excel workbook will not open, first try opening Excel in Safe Mode, then use File >…
- Delete a Page in Word with Ctrl+G: Step-by-Step GuideTo delete a page in Microsoft Word on Windows, click in the page you want to remove, press…
- How to Archive Emails by Date Range in OutlookTo archive Outlook emails from a particular date range, search for messages received within the dates, check the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.