Hi - i am running a multi page Excel 2003 workbook that currently sizes at 5.8 meg. In an effort to reduce the file size i have tried deleting a couple of sheets that are no longer used, and the file size increases!! Is there any way of "compacting" the file? I have tried saving, shutting and reopening but that doesn't make any difference.
Create a new blank work book. Open the one with the data in it and select all the sheets you require by holding down the CTRL key and clicking on the tabs at the bottom. Right click on the tabs at the bottom of the sheets you selected to be copied. Select Move or Copy In the drop down box select the new workbook you opened (Book 2) Put a tick in the Create a Copy box (this will keep the data in the original workbook as well) Then click OK You should now have the required sheets in a new workbook which you need to save. You can then zip it if it is still too big.