How to compress a 10 MB file?

pkohli

Board Regular
Joined
Aug 2, 2005
Messages
71
Hi

I have a file that is 10 MB in size. Is there any way I can compress the file to make it small?

Thanks
Pooja
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi Pooja,

It depends. Is the file 10MB because it truly contains 10MB of data (this would correspond to roughly 100,000 cells of numbers)? Or is it 10MB because of "bloat" resulting from the usedrange problem?

If you are not familiar with the usedrange problem, there is a UsedRange property for each worksheet. This is the range of cells that Excel saves when the workbook is saved. It is supposed to the the smallest rectangular block of cells that contains every cell that has been changed--containing either data, formatting, validation, comments, etc. But there is a problem with Excel that it does not always collapse the usedrange properly when data are deleted from a worksheet. So Excel saves cells that don't need to be included in the file, and this increases the file size. You can check whether you have a problem by selecting any cell on a worksheet and typing Ctrl-end (using the end keyboard key). The selection will then go to the last cell (lower right corner) of the usedrange. If this cell is outside the range of the sheet containing data then you have usedrange bloat. There are numberous posts on this board regarding this problem and how to clean it up.

If you truly have 10MB of data your only option is to figure out a way to store less of it. I should mention that 100,000 cells of number sounds like a lot, but this is the number of cells in the range A1:CV1000 in one worksheet.

I hope this helps.

Keep Excelling.

Damon
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,791
That was a great read Damon and thanks for that. pkohli... I've noticed a file size reduction by Zipping a file, opening it, and then saving it again. Seems like the Zip sheds some extra stuff? Anyways, I'm sure Damon's route is the way to go but you might want to trial something simple first. HTH. Dave
 

pkohli

Board Regular
Joined
Aug 2, 2005
Messages
71
Hi Damon

Thanks a lot for your advise. Yes i have a problem of usedrange bloat in the sheet. I m now tring toind a way out to clean the bloat.

Many Thanks for the help!

Pooja
 

Forum statistics

Threads
1,136,268
Messages
5,674,734
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top