File Size Too BIG

[Soniya]

Hi All,

I have a workbook with 13 sheets having SQL Query. Even
though the data size is not so big the file size seems to
be unduley BIG. The data is average 15,000 rows per sheet
with 41 columns.

Now the file size is 75 MB. Is there something wrong or I
have to do something in order to make the file size
normal (small)

TIA

Soniya

 

[Ron de Bruin]

Hi Soniya

Check out
http://www.contextures.com/xlfaqApp.html#Unused

 

[keepITcool]

Hi soniya,

It might be following:
http://support.microsoft.com?kbid=293828
BUG: Excel File Size Grows When You Edit or Update ADO Recordset on Excel
Spreadsheet


Opening and saving in excel should solve the problem.


Also it may be a good idea NOT to store the data,
by setting the SaveData property of the querytable to False




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


Soniya wrote in message

 

[keepITcool]

Soniya!....

I just realized the numbers you were giving:

13 sheets, 15000 rows, 41 columns.
Not accounting for overhead..assume you'd use 8 bytes per cell...
?13&*15000&*41&*8&
63 960 000

if you create an empty workbook and fill all those cells
with a simple 1..

you DO have a 54MB workbook.

you must split the data into various workbooks.
AND consider if you REALLY need all those columns.





keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


Soniya wrote in message