Excel File Grows From KB to MB Formatting Weight Audit
The data is three pages. The file is 22 MB. Something invisible is stored inside that workbook — and since an xlsx file is just a zip, you can weigh its parts and name the culprit.
✍️ Technical Anshu🪟 Windows 10 / 11⏱️ 6 minute read
🎥 Watch the video — heavy formatting quietly inflating an Excel file is the same family of trouble, found from the size side
Guessing which sheet is bloated wastes time. An audit is better: an .xlsx file is a zip archive of XML parts, and the size of each part tells you where the weight lives. A worksheet part of 20 MB next to siblings of 50 KB is a signed confession; a giant styles.xml accuses the style list instead. Five minutes of weighing replaces an hour of poking around — and repeating the audit after the cleanup proves the weight actually left.
Inside the xlsx zip — the part sizes name the culprit
xl/worksheets/sheet1.xml 212 KB
xl/worksheets/sheet2.xml 19.8 MB <- the weight lives here
xl/worksheets/sheet3.xml 48 KB
xl/styles.xml 1.2 MB <- style overload also present
xl/media/ 0 files (no pictures involved)
Example listing. Sort the extracted parts by size: worksheet XML and styles.xml are the two formatting suspects; a heavy media folder means pictures instead.
1
Weigh the Parts of a Copy
The audit runs on a duplicate, so the method is completely safe. Never rename your only copy of a file.
Copy the workbook in Explorer, and rename the copy's extension from .xlsx to .zip
Open the zip and sort the contents by size, looking inside the xl folder
Read the three suspects: xl/worksheets (one XML per sheet — data plus its formatting), xl/styles.xml (the workbook's format and style definitions), and xl/media (embedded pictures)
The biggest part is your answer. Everything after this step is just confirming and fixing what the scales already told you
2
Match the Heavy Sheet to Its Used Range
A fat worksheet XML almost always means the same thing: a small amount of data wearing an enormous formatted territory.
Open the original file, go to the accused sheet and press Ctrl + End
If Excel lands near row 1,048,576 while data ends at a few hundred rows, whole columns or rows were painted — the XML is big because a million cells carry formats
Fix with the delete-and-save method: delete the rows below and columns right of the data, then save
If Ctrl + End lands sensibly but the XML is still fat, suspect thousands of individually formatted fragments rather than one painted block — the cleanup is the same, the selection just takes longer
3
When styles.xml Is the Heavy Part
A large styles.xml with modest worksheet parts tells a different story: the workbook's style catalogue itself is the weight.
Open Home → Cell Styles and scroll the gallery — hundreds of entries, duplicates and foreign names confirm the audit
This is style overload, usually imported by years of pasting from other workbooks
The repair is gallery cleanup: right-click unused custom styles → Delete, on a copy, in batches
Re-audit afterwards — styles.xml should shrink visibly; if it does not, the styles are in use and the honest route is rebuilding the sheet clean rather than forcing deletions
4
Rule Out the Innocent Suspects Honestly
Not every fat file is a formatting case, and a good audit says so when it finds one.
A heavy xl/media folder means pictures: pasted screenshots and photos. Compress them via Picture Format → Compress Pictures instead of touching formatting
A heavy xl/drawings part points at shapes, charts or floating objects accumulated over edits
A heavy xl/sharedStrings.xml means genuinely lots of text data — the file may honestly be big, and no cleanup will change that
Naming the true cause is the audit's whole job — including when the answer is 'this file is fine'
5
Fix, Re-Weigh, and Keep the Receipts
Audits are most powerful as a before-and-after pair. Numbers end arguments about whether a cleanup worked.
After the repair, repeat the copy-rename-weigh routine on the cleaned file
Compare three numbers: total file size, the heaviest worksheet XML, styles.xml
Note the before and after sizes on the ticket or in a comment on the file — the next person inherits evidence, not folklore
For shared office files, a yearly five-minute audit catches bloat while it is still a trim instead of a rebuild
🔴 Always audit a copy, never the original. Renaming your only copy of a workbook to .zip and poking inside invites accidents. Duplicate the file, audit the duplicate, repair the original — in that order, every time.
🎥 Watch the Complete Fix in the Video
Watch the video to see how formatting weight turns into hangs and freezes — the audit above finds the same weight from the file side.
On a copy, yes — you are only reading. An xlsx is a standard zip archive of XML files, and Windows opens it without any special tools. Never rename or edit the only copy of an important workbook; duplicate it first and explore the duplicate.
The biggest folder is xl/media, not worksheets. What then?
Then your weight is pictures, not formatting — usually screenshots pasted at full camera resolution. Select a picture, use Picture Format → Compress Pictures, choose a web or email resolution and apply to all pictures. The formatting cleanups on this page will not help a media problem, which is exactly what the audit is for.
Can one formatted sheet really add tens of megabytes?
Yes. Formatting applied to whole columns stores format records across a million rows per column, and the worksheet XML grows to match. A single painted column can outweigh the file's actual data many times over — the audit's sheet-size comparison makes this visible in one glance.
This guide is based on the Technical Anshu Excel hanging after colour formatting video • Stuck on a step? Ask in the video comments — you will get an answer there 🙏