A workbook that looks like a few sheets of numbers can balloon to tens of megabytes for reasons that never appear on screen. Unlike a Word document, where images are almost always the culprit, Excel bloat usually comes from things you can’t see just by scrolling through the data.
| Cause | Why it bloats the file | Fix |
|---|---|---|
| Pivot table cache | A PivotTable keeps its own cached copy of the source range so it can refresh instantly — often several times larger than the visible data, and it persists even after the source rows are deleted | File → Options → Data → uncheck “Enable data to be saved with the workbook,” or delete and recreate the pivot from a trimmed range |
| Formatting on entire rows/columns | Selecting a whole column and applying a fill, border, or number format tells Excel that formatting exists across all 1,048,576 rows, even if nothing visible changes | Select only the used range, copy it to a new sheet, and check whether the size drops |
| Embedded images and objects | Screenshots pasted into cells, logos, or charts with embedded data are stored at their original resolution, often far higher than a spreadsheet needs | Compress Excel re-encodes every embedded image automatically, leaving data and formulas untouched |
| External links and query connections | Data connections to other workbooks, databases, or Power Query sources leave cached results and connection metadata even after the link is broken | Data → Edit Links, and remove connections no longer needed |
| Legacy .xls format | The older binary format is generally less space-efficient than the XML-based .xlsx for the same content | File → Save As → Excel Workbook, with no other changes |
Pivot table cache is the single biggest hidden cause, since it’s the least visible — a PivotTable’s cache can dwarf the actual data it’s built from. Formatting applied to entire rows or columns is the second most common, and often the most surprising, since nothing about the sheet looks different before and after the fix. Embedded images are the one place this genuinely resembles a Word document’s bloat, and the one this site’s own tool addresses directly.
If the destination is someone reading the numbers rather than recalculating them, sending the spreadsheet at all may be the wrong move regardless of size — a workbook exposes formulas, hidden sheets, and old data by default, and invites accidental edits (see Share a Spreadsheet Nobody Can Change). Converting to PDF with Excel to PDF sidesteps the size problem entirely for that use case — a PDF of the same visible content is typically far smaller than the workbook that produced it, and if it’s still large afterward, Compress PDF shrinks it further.
Related reading: Why Is My Word Document So Large? covers the equivalent bloat causes for .docx files, mostly image-related rather than formatting-related.
Worried compression will break something? Does Compressing an Excel File Break Formulas or Macros? answers that directly — the short version is that formulas, macros, and cell data are untouched.
If embedded images are the cause, the free Compress Excel tool fixes it directly. For sharing rather than editing, Excel to PDF works the same way — skip the sign-up, skip the watermark, nothing kept on our servers.