I have a small and simple file in *.XLS with only one sheet, on this sheet just many cells with small text on number. (file size 24Kb)
But I made a lot of changes, copy and paste, extend formula, save... afterwards I deleted most of these changes and make 4 duplicates of this sheet with few data.
Now my new file is VERY huge : 2.5Mb !
Where is the hidden data and how can I delete it ?
I have the same problem on real file with 300 sheets and 1 picture on each sheet : file size 280Mb
This is what makes the file so large: Excel is picking up a lot of empty cells and thinks there's data in them, which then it tries to save into the XLSX file on disk, and because it needs to keep references to all those hundreds or thousands of cells, the file size gets overblown.
A good way to reduce your Excel file size is to get rid of the empty rows and columns. Here's how to do that: Select all unused rows and columns (Shortcut = Ctrl+Shift+Right/Down Arrow) Right-click > Delete.
I save files in .XLSB format to cut size. The XLSB also allows for VBA and macros to stay with the file. I've seen 50 meg files down to less than 10 with the Binary formatting.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With