Leading the way in Microsoft Office Development

There are several things that you could try in order to try and reduce the file size of your workbooks.

1) Delete any empty rows below your data.

Check the "used range" on each worksheet and delete any unnecessary rows, to find the last used row, press (Ctrl + End).

The "used range" is only updated when you close and reopen the workbook though.

2) Save the workbook with the macros disabled, then reopen and enable macros.

3) Export all VBA modules, close and then import them all again.

4) Remove the formats from any blank cells. press (Edit > GoTo) special, select "blank". Then select (Edit > Clear All).

5) Check that you are not saving the workbook as multiple versions (i.e. as "Excel 5.0/95 Workbook (*.xls)" ).

6) Delete any custom number formats which are not being used or are not necessary.