How to compact an excel?

**jjaviergg** · 06-16-2013, 01:27 PM

I have a 18 mb. excel .. I've deleted aprox the half of worksheets and the excel has the same size.

After that I've made a copy of one of active worksheets and the excel size is now of 32 mb.

Is there any method to optimize or compress?

Best regards
Jose Javier
Madrid (Spain)

**-AJ-** · 06-16-2013, 01:37 PM

Only use formulas, charts, macros and formatting that is completely necessary. Remove the rest. Those 4 things can drastically increase the file size.

**Kyle123** · 06-16-2013, 01:44 PM

and save it as xlsb, also make sure that you don't have huge ranges of unused cells. Copy the active ranges into a new workbook, not the whole sheet by selecting the cells

**jjaviergg** · 06-16-2013, 02:42 PM

thanks all... if I save the excel in binary format (xlsb) as you said.. there is any consideration to have?.. is completely operative?

**jjaviergg** · 06-16-2013, 02:45 PM

sorry I forget to say that is an xlsm excel

**martindwilson** · 06-16-2013, 04:46 PM

try removing excess formats
http://support.microsoft.com/kb/244435

**jjaviergg** · 06-17-2013, 03:05 AM

thank you....

**akhileshgs** · 06-17-2013, 03:09 AM

Hi,
Please mark your post as solved if you got what you want

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save