Size Jump

S

Supe

I have a person I work with who had an Excel sheet that has about 40 tabs
with roughly 200 rows in each tab. There are some cell that get information
from other tabs using =tab name, cell. The file size was 3,278 KB. She made
some changes to this file where she added about 800-900 rows to each tab and
also added an IF statement in the cells in some columns in all of the tabs.
The file size is now 30,673 KB. Could the file size increase that much by
adding these rows and these IF statememts? Seems like a pretty big jump.
 
J

Jim Thomlinson

Usually a significant size jump for no apparent reason is caused by unused
cells that are not being cleaned up by XL. Check out the scroll bars on each
sheet. Do they allow you to scroll well past the end of the data. If so then
you need to clean up the unused cells by deleting all rows below and to the
right of the last used cell. Once you have done that on all sheets you need
to save the workbook. When this is done the size fo the workbook should be
much more reasonable and the scroll basr shoul only take you to the end of
the populated cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top