Been having problem with Excel file size whenever saving a workbook with lots of formula converted to values. A small file with formula of less than 30KB can grow to as big as 13MB.
Found a solution to this. Download Microsoft Excel Excess Formatting Cleaner Add-in.