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.