bloat

  1. L

    Question on importance of releasing variables..

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

    Troubleshooting File Bloat

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

    Tip to Remove File Bloat Having Negative Effect

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

    XL 2008 sheet 'bloat'

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

Watch MrExcel Video

This Week's Hot Topics

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