How to reduce an Excel file’s size
Reduce the part that is actually large. Measure the package, then remove pictures you do not need, clear or narrow pivot caches, delete phantom rows, and consolidate formatting. Save a new copy and measure again. A smaller file that Excel repairs on open is not a win. Neither is a smaller file that dropped the only copy of the source data you still needed.
Measure, then pick one change
Open the file in the pivot cache checker and the size checker. Write down the largest group and its size. The rest of this guide is a menu. Do the item that matches the largest group. Doing all of them on a file whose only problem is one pasted screenshot wastes an afternoon and risks a formula you did not mean to touch. Keep the original file. Work on a copy with a new name.
Pictures and embedded files
Select a picture, open Picture Format, and use Compress Pictures. Choose a resolution that matches how the report is read. Delete pictures that are decorative. If the same logo appears on every sheet, one copy in the header is enough. Embedded workbooks and PDF objects under embeddings are easy to miss because they do not look like a big grid. The size table names them. If an embedded object is the source of truth, link to it or store it beside the workbook instead of inside it, and accept that the link is now an external link you should keep intact.
Pivot caches
Open each pivot, note where it points, and decide whether the cached rows need to travel with the file. PivotTable Options, on the Data tab, includes “Save source data with file”. Clearing that flag and saving drops the records part and forces a refresh later. That is the right trade when the source sheet or the database is still available. It is the wrong trade when you are emailing a snapshot to someone who cannot refresh. Unused pivots can be deleted outright. Two pivots that do not share a cache can be rebuilt so they do. Afterward, the cache checker should show a smaller records total or fewer caches.
The grid itself
Run the used-range check. On each phantom sheet, press Ctrl+End. Delete entire rows below the last real value and entire columns to the right, then save. If you use tables, resize the table instead of leaving it standing over empty rows. Clear formatting below the table if style-only cells are the reason the range will not shrink. Remove unused cell styles from the styles gallery if the styles part is the heavy one. None of this requires a cleaner add-in. It requires knowing which sheet is lying about its size.
When you want the numbers from your own workbook, see whether cache records dominate.
Formatting and text
Conditional formatting that was copied cell by cell should become one rule for the column. Data bars and color scales count. They are useful and they are not free when duplicated a thousand times. For text, ask whether the column belongs in this file. A notes field with a unique sentence per row will dominate shared strings. If the notes are not needed for the report, drop the column on the copy you send. Keep it in the system that owns the text.
Save in the right container
After the content is smaller, Save As .xlsx if the file has no macros, or .xlsm if it does. .xlsb is reasonable when the remaining workbook is still large and you want faster opens, and when your audience can open .xlsb. It is a poor choice when the next person needs to inspect the XML or run the formula checks on this site. Avoid “binary” as a way to hide a cache you did not want to think about.
Check the result like a change
Open the new file in Excel. Calculate. Click through the pivots and one chart. Then drop it on the size checker. The largest part should have moved. If the file is smaller but Excel says it found unreadable content, stop and go back to the previous copy. A quiet reduction is one where both the package check and the business check pass.
A sequence that is hard to regret
Keep three names on disk while you work: the original, the copy you are editing, and the last copy that still opened cleanly. After each removal, save the editing copy, open it once, and measure it. If the measure improved and Excel did not repair anything, replace your “last clean” copy with this one. If Excel repairs, discard the editing copy and continue from the last clean file. That habit matters more than any single trick in this guide. It also keeps you from combining a picture compression, a cache clear, and a row deletion into one save you cannot explain. The Audit score will move when a size band or a phantom range goes away. Treat the score as a checklist of findings, not as a grade you must maximize. A file that is honestly 12 MB because it contains 12 MB of data should stay 12 MB. When you send the reduced copy, say what you removed in one line, such as “dropped the cached pivot source; refresh from the data sheet.” The next person will not have to rediscover whether the smaller file is missing something they needed.
What to tell the person who owns the file
A smaller workbook is a change in what the file contains. Say what you removed. “Compressed the cover image and dropped the pivot’s saved source data” is a useful sentence. “Ran a cleaner” is not. The owner needs to know whether a refresh is now required, whether a logo looks softer, and whether a sheet of notes was left out of the copy on purpose. Put that sentence in the email with the file. If you cannot write it, you do not yet know what the size check changed, and you should measure the before and after parts again before you send anything. Keep the unreduced original for as long as your retention rules allow. The reduced file is a distribution copy, not automatically the system of record.
Related reading
The closest repair notes are Why the file got large and Phantom rows and the last cell .
Walk the same checks in order with the Workbook audit checklist.
The terms behind this guide are Pivot cache and Used range .
The paired check for that note is the Excel file size checker.
Questions people ask before trusting the result
How much smaller should it get?
There is no universal percent. If a 40 MB cache was the problem and the file is now 4 MB, that was the right change. If the file drops by a few percent, you trimmed the wrong part.
Will zip compression on the folder help?
The xlsx is already a ZIP. Zipping it again helps only while it sits inside another archive. Excel will not keep that outer zip when the file is opened.
Can I reduce size without Excel?
You can measure it here. Removing parts safely is an Excel save, because Excel rewrites relationships and content types. Hand-editing the ZIP is how files become unreadable.
Does removing formatting change numbers?
Deleting styles and conditional formats changes appearance. It should not change values. Pivot cache changes can change what a pivot shows until it is refreshed. Know which one you are doing.
What if the file is on SharePoint and still looks large?
Sync clients sometimes show a stale size. Download a fresh copy and measure that file. The package on disk is the one that matters.