MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HELP! Workbook too big!

Posted by TWood on October 15, 2001 3:39 AM

I have a workbook which is way too big. I need all the sheets that it currently has but I also need to reduce the size. Is there any way I can do this (ex) deleting cells I don't use? I tried this but the cells do not disappear aster I delete them.

Posted by Don C on October 15, 2001 7:10 AM

The worksheet size is fixed, so deleting rows or columns won't get you anywhere.

Changing formulas to values will reduce the size considerable.

For example, I have some stock tracking files with activity entries on each row. Once the calculations in a row are completed, I don't need them anymore, so periodically I do a copy/paste_values on rows that do not need to be recalculated anymore. Keeps the file size down considerably.