Excel File Too Large to Send? Fixes and Workarounds

How-to basics · Updated November 20, 2026

Yes—if an Excel workbook is too large for an email attachment, send a sharing link instead, or reduce the workbook’s size before attaching it. Excel does not have one universal “too large to send” limit: the restriction usually comes from the email service, company settings, or the way the workbook is stored.

Send the workbook as a link

For a large workbook, a cloud link is usually the quickest and most dependable solution. Save or upload the file to OneDrive or a SharePoint library, then use Excel’s Share button to choose who can open it and whether they can edit it. You can also create a link from the file’s sharing controls in OneDrive or SharePoint and paste that link into your email.

In Microsoft 365 for Windows, open the workbook and select Share near the upper-right corner. If the workbook is stored locally, Excel may prompt you to upload it to OneDrive first. Follow the prompts, set the link permissions, and send the link rather than attaching the file. In Excel for Mac, use the Share button as well; the exact prompts can vary with the account and where the file is saved. Excel for the web also has a Share button.

Before sending, check the audience setting. A link may be restricted to named people, people in your organization, or anyone who has the link, depending on your account and administrator’s policies. Use the narrowest permission that suits the task. If recipients only need to review the workbook, avoid giving edit access. A link can also be revoked or its permissions changed later, unlike a copy already downloaded as an attachment.

Why an Excel attachment gets rejected

An .xlsx or .xlsb file can be perfectly valid in Excel and still be rejected by an email system. Email providers set their own maximum message sizes, and workplace administrators may set stricter limits. The limit may apply to the whole message, not just the workbook, so the message text, signature, and other attachments can matter too.

Attachments are also encoded when email is transmitted, which can make them roughly one-third larger in transit than their on-disk size. A 19 MB workbook, for example, may take up about 25 MB as an encoded attachment, before other message content is counted. This is one reason a file that appears to be under a service’s advertised limit can still fail. Gmail, for example, allows attachments up to 25 MB in total and uses a Google Drive link for larger files; other services and business mail systems have different rules.

Look at the exact bounce message or warning. It may identify a message-size limit, a blocked file type, or a recipient mailbox restriction. If the message was sent from a work account, ask the IT administrator about the organization’s attachment policy rather than assuming the workbook itself is damaged.

Email limits are not Excel workbook limits

Excel’s worksheet capacity and an email service’s attachment limit are separate things. A worksheet in current desktop Excel can contain up to 1,048,576 rows and 16,384 columns, but reaching those dimensions is not required for a workbook to become large. Pictures, imported data, pivot caches, embedded objects, and formatting applied to large ranges can all add weight.

There is no single small file-size ceiling that applies to every Excel workbook. The practical limits depend on the Excel edition, available memory, whether the app is 32-bit or 64-bit, the workbook’s contents, and the device. A file that opens on one computer may be slow or difficult to use on another, especially if it has extensive formulas or a large data model. So “too large to email” does not necessarily mean “too large for Excel,” and a file that sends successfully is not necessarily easy to work with.

Reduce the workbook size safely

Make a separate copy before removing data, changing formats, or cleaning up a complex workbook. Then try the changes that match what is taking up space:

  • Resize or compress pictures. Select a picture and look for Picture Format > Compress Pictures in Windows Excel. Choose an appropriate resolution and apply it to the pictures you intend to reduce. The ribbon may differ on Mac, so look for picture compression options after selecting an image. Keep an original copy if image detail matters.
  • Remove unused rows, columns, and formatting. Check the bottom and right edge of each sheet for stray content or formatting far beyond the data. Select genuinely unused rows or columns, use Home > Clear > Clear All, and save a copy. Simply pressing Delete may clear cell contents without removing formatting. Avoid clearing ranges that contain formulas or information you need.
  • Remove redundant objects and data. Delete duplicate pictures, obsolete sheets, unnecessary embedded files, or data that can be obtained again from its source. Review pivot tables and external connections before changing them: caches or connections may be needed for refreshes, and removing them can affect how the workbook works.
  • Review imported data and formulas. Large sets of repeated raw data or formulas filled far beyond the used range can increase file size and slow recalculation. If recipients need only a finished report, consider making a separate copy with only the required sheets or values. Keep the working original if people need to refresh queries, inspect formulas, or continue analysis.
  • Save, close, and reopen the copy. After cleanup, save the workbook, close it, and check the saved file’s size in File Explorer on Windows or with Get Info on a Mac. Reopening helps confirm that the file still works and that the changes were saved.

Do not delete information just to get below a guessed target. First identify what the recipient needs: a live model, a refreshable data set, or simply a readable report. That decision determines what can safely be removed.

Choose the right file format

For most recipients, keep the workbook as .xlsx. It is the standard modern Excel workbook format and is widely compatible. Renaming the file extension does not reduce its size or convert its contents.

If a workbook contains a lot of data, saving a copy as an Excel Binary Workbook (.xlsb) may make it smaller or faster to open, although the result varies by workbook. In Microsoft 365 for Windows, use File > Save As, choose the location, and select Excel Binary Workbook (*.xlsb) as the file type. Check that recipients can use the format before sending; some non-Excel tools handle it less conveniently. If the workbook contains macros, .xlsb can retain them, while saving a macro-enabled workbook as .xlsx removes its VBA macros. Preserve the original and confirm that critical features still work in the converted copy.

Putting an .xlsx file in a ZIP archive often does little to reduce it because .xlsx files are already compressed. ZIP can still help package several files together, but it may not solve an attachment-size problem. Some email systems also block archives, so check the recipient’s rules.

Choose between an attachment and a sharing link

An attachment gives the recipient a separate copy at the time you send it. That can be useful when they need an offline snapshot, when they do not have access to your organization’s cloud storage, or when the workbook must not change after delivery. But if you later edit the original, the recipient’s copy does not automatically update, and multiple attachments can create confusion over which version is current.

A cloud link can point everyone to the same current file and avoids carrying the full workbook in the email. It is usually better for collaboration and large files, but access depends on permissions, internet access, and the recipient’s account or organization policies. Someone who downloads a copy can still have a separate version, so explain whether they should edit online or download a snapshot.

Consider the workbook’s sensitivity as well as convenience. Financial details, personal information, or confidential business data should not be placed behind a broadly accessible link. Use approved storage, verify recipients, choose restricted permissions, and follow your organization’s data-handling rules. If the recipient cannot access your cloud service, ask IT about an approved transfer method rather than switching to an unapproved public file-sharing site.

When the file is still too large

If a link is unavailable and a smaller attachment is essential, find out the actual limit before making further changes. Ask the recipient or mail administrator for the maximum message size and any restrictions on formats or archives. Then compare that limit with the saved workbook’s size, remembering that email encoding and other attachments add overhead. Leave a margin rather than aiming to land exactly on the stated maximum.

If the workbook is large because it contains data the recipient does not need, create a clearly named distribution copy and remove only the unnecessary material. For a read-only report, a PDF export can be easier to send and view, but it is not a substitute for an interactive workbook: recipients generally cannot use it to recalculate formulas or refresh data as they can in Excel. If the workbook must remain functional and is too large for email, a properly permissioned cloud link or an organization-approved file-transfer service is usually the better answer.

Finally, check whether the problem is size or a different sending error. A file may be blocked because of its extension, a damaged workbook, a full mailbox, or a recipient-side policy. Try sending a small harmless test file if appropriate, and read the error carefully. Renaming a file or repeatedly retrying the same oversized message will not overcome a server-enforced limit.

Frequently Asked Questions

How do I send an Excel file that is over 25 MB?
Upload it to OneDrive or another approved cloud service and send a restricted sharing link. The 25 MB figure applies to some services, not all; your email provider or workplace may have a different limit.

Will zipping an Excel file make it small enough to email?
Sometimes, but often not by much. The .xlsx format is already compressed, so a ZIP archive may barely shrink it. Check the new archive’s size and make sure the recipient’s mail system accepts ZIP files.

Does saving as .xlsb always reduce file size?
No. It can reduce some workbooks, but the difference depends on the workbook’s contents. Save a separate copy, confirm the recipient can open it, and test important formulas, connections, and macros.

Can I send a large Excel file through Outlook?
It depends on your Outlook account and mail system’s message-size limit. Outlook may offer to upload an attachment to OneDrive and send a link, but availability and behavior depend on the account and organization settings. If it does not, upload the workbook yourself and share it with suitable permissions.

Is a large Excel file unsafe or corrupted?
No. Size alone does not prove that a workbook is unsafe or damaged. A large file may simply contain substantial data or media. If Excel reports a problem opening it, use a backup and investigate that specific error separately from the email limit.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.