[SOLVED] File size is huge

I have a workbook that is compirsed of 3 sheets. Sheet1 has 13 columns and 90
rows. Sheet2 has 13 columns and 57 rows. Of the 13 rows in Sheet1 and
Sheet2, 4 of the columns have list boxes for each row. Sheet3 has 5 columns
and 4 of the 5 columns have 20 rows of data and the 5th column has 110 rows
of data. Sheet3 contains the data that list boxes in sheet1 and sheet2 use.
There are no complex calculations. I wrote one VB module which adds a fourth
color for conditional formatting in sheet1 and sheet2. The conditional
formatting is only used in 1 column. How can this workbook size be alomst
6MB?
I've worked with several workbooks that had over 20 sheets, 40 columns each
and over 300 rows and several complex calculations and the size of those
sheets never exceeded 3MB.

Check out the scroll bars. Do they allow you to scroll to 65,536 or IV? If so
then the cells have been initailized and even though they are empty they
still take up space. Delete (not clear contents) everything below and to the
right of the last populated cell. Now save the workbook. The scroll bars
should change and only allow you to scroll to the end of the data... and the
workbook will be a whole lot smaller.
--
HTH...

Jim Thomlinson


"Lewis" wrote:

> I have a workbook that is compirsed of 3 sheets. Sheet1 has 13 columns and 90
> rows. Sheet2 has 13 columns and 57 rows. Of the 13 rows in Sheet1 and
> Sheet2, 4 of the columns have list boxes for each row. Sheet3 has 5 columns
> and 4 of the 5 columns have 20 rows of data and the 5th column has 110 rows
> of data. Sheet3 contains the data that list boxes in sheet1 and sheet2 use.
> There are no complex calculations. I wrote one VB module which adds a fourth
> color for conditional formatting in sheet1 and sheet2. The conditional
> formatting is only used in 1 column. How can this workbook size be alomst
> 6MB?
> I've worked with several workbooks that had over 20 sheets, 40 columns each
> and over 300 rows and several complex calculations and the size of those
> sheets never exceeded 3MB.
>

Thanks Jim.
- Lewis

"Jim Thomlinson" wrote:

> Check out the scroll bars. Do they allow you to scroll to 65,536 or IV? If so
> then the cells have been initailized and even though they are empty they
> still take up space. Delete (not clear contents) everything below and to the
> right of the last populated cell. Now save the workbook. The scroll bars
> should change and only allow you to scroll to the end of the data... and the
> workbook will be a whole lot smaller.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Lewis" wrote:
>
> > I have a workbook that is compirsed of 3 sheets. Sheet1 has 13 columns and 90
> > rows. Sheet2 has 13 columns and 57 rows. Of the 13 rows in Sheet1 and
> > Sheet2, 4 of the columns have list boxes for each row. Sheet3 has 5 columns
> > and 4 of the 5 columns have 20 rows of data and the 5th column has 110 rows
> > of data. Sheet3 contains the data that list boxes in sheet1 and sheet2 use.
> > There are no complex calculations. I wrote one VB module which adds a fourth
> > color for conditional formatting in sheet1 and sheet2. The conditional
> > formatting is only used in 1 column. How can this workbook size be alomst
> > 6MB?
> > I've worked with several workbooks that had over 20 sheets, 40 columns each
> > and over 300 rows and several complex calculations and the size of those
> > sheets never exceeded 3MB.
> >

Jim,

The excess rows and columns would not delete. I did change the height of
the excess rows to 1 and the width of the excess columns to .11 and this
reduced the file size to less than 200KB.
Any thoughts on why I was not able to delete the excess rows and columns?

-Lewis

"Jim Thomlinson" wrote:

> Check out the scroll bars. Do they allow you to scroll to 65,536 or IV? If so
> then the cells have been initailized and even though they are empty they
> still take up space. Delete (not clear contents) everything below and to the
> right of the last populated cell. Now save the workbook. The scroll bars
> should change and only allow you to scroll to the end of the data... and the
> workbook will be a whole lot smaller.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Lewis" wrote:
>
> > I have a workbook that is compirsed of 3 sheets. Sheet1 has 13 columns and 90
> > rows. Sheet2 has 13 columns and 57 rows. Of the 13 rows in Sheet1 and
> > Sheet2, 4 of the columns have list boxes for each row. Sheet3 has 5 columns
> > and 4 of the 5 columns have 20 rows of data and the 5th column has 110 rows
> > of data. Sheet3 contains the data that list boxes in sheet1 and sheet2 use.
> > There are no complex calculations. I wrote one VB module which adds a fourth
> > color for conditional formatting in sheet1 and sheet2. The conditional
> > formatting is only used in 1 column. How can this workbook size be alomst
> > 6MB?
> > I've worked with several workbooks that had over 20 sheets, 40 columns each
> > and over 300 rows and several complex calculations and the size of those
> > sheets never exceeded 3MB.
> >