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.
Pivot table cache
This is the single biggest hidden cause. A PivotTable doesn’t read live from your data each time — it keeps its own cached copy of the source range baked into the file, so the pivot can refresh instantly. That cache can be several times larger than the visible data, and it persists even if you later delete the source rows. Fix: File → Options → Data → uncheck “Enable data to be saved with the workbook,” or delete and recreate the pivot from a trimmed range.
Formatting applied to entire rows or columns
Selecting an entire column and applying a fill color, border, or number format — a common habit — tells Excel that formatting exists across all 1,048,576 rows, not just the ones with data in them, even though nothing visible changes. Excel has to store that formatting information regardless of whether cells are empty. Fix: select only the used range, copy it to a new sheet, and check whether the size drops — it often does, dramatically.
Embedded images and objects
Screenshots pasted directly into cells, company logos in headers, or charts with embedded data are stored at their original resolution, often far higher than needed for a spreadsheet. Fix: right-click an image → Format Picture → Compress in Excel itself, or skip the manual step entirely — Compress Excel does exactly this automatically: upload the file and it re-encodes every embedded image to a screen-friendly size, leaving your data and formulas untouched.
External links and old query connections
Data connections to other workbooks, databases, or Power Query sources can leave behind cached results and connection metadata even after the underlying link is broken or no longer used. Fix: Data → Edit Links, and remove connections no longer needed.
Legacy .xls format
The older binary .xls format is generally less space-efficient than the XML-based .xlsx for the same content. Re-saving as .xlsx alone (File → Save As → Excel Workbook) sometimes recovers meaningful size with zero other changes.
If you only need people to view it, not edit it
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? — the equivalent bloat causes for .docx files, mostly image-related rather than formatting-related
Ready? If embedded images are the cause, try the free Compress Excel tool now. For sharing rather than editing, Excel to PDF works the same way — no sign-up, no watermark, and your file is never stored.