bloat

My question is really how important is this? I am a real newbie so I haven't really done this before. I recently created a fairly complex (for me) workbook. And it has many (maybe 30) public variables which are used and changed at various points in the code. Recently this workbook has been...

File bloat happens from time to time and I'm usually able to fix such files by manually recreating them and making sure to minimize the number of different cell formats. I just went through that process on a workbook of mine which had bloated up to a ridiculous size of 4MB (considering it...

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...

I started creating a workbook in 2004 but had to change to 2008. As I continued working in 2008, (It IS backward compatible isn't it?), I started getting a *LOT* of XL crashes and hangs. Thanks to several people on this forum, I realized that I had a corrupted workbook. So, I copied and...