HELP! Workbook too big!
Posted by TWood on October 15, 2001 3:39 AM
Hi,
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.
