This is definitely the most common source of large Excel file sizes, and fortunately one of the easiest to fix.Įxcel has a “used range” for every sheet in your workbook.
If you don’t want to alter the contents of the workbook, try these options first. In this section are the easy and straightforward options to cut down on file size. Sort your data when using formulas that look up values Use a Watch Window to always check on specific cells Check for and delete unnecessary hidden sheets
