Tip to Remove File Bloat Having Negative Effect

[AshleyH]

I read a tip to remove unused cells from the used range to reduce the file size. I located the end cell through Edit - Go To - Special - End Cell and found my end cell was 200 rows beneath the last cell of data.

As the tip instructed, I highlighted the rows from directly beneath my data to this culprit end cell, and deleted the rows through Edit - Clear - All. Saved the workbook as a new file and was dismayed to find the new file was 100 KB larger then the original.

Why'd it do this?

 

[repairman615]

Hello,

Welcome to the Board.

I can not say I have mass amounts of experiance with this. The Edit / Clear got my attension.

If you did not mean delete, then what happens if you highlight the entire rows, not just the range, then use rightclick / Delete?

 

[jolivanes]

AshleyH

http://www.mrexcel.com/forum/showthread.php?t=459349

http://www.contextures.com/xlfaqApp.html#Unused

http://www.appspro.com/Utilities/CodeCleaner.htm

Check out these sites. There might be help there you'd want

Good Luck

John