How do I minimize Large xls file?

[Pandi]

I have File that his size is 56Mb, This file contain data base from
Oracle (4 sheets with 35000 row each).
I don't have in the file any function only data.
How can I minimize the file to ?
Tanks

 

[Hardy]

3 main tips for reducing file size;

Columns take up more memory than rows, so the fewer columns the
better.

Remove any formulas that are un-necessary, i.e. calculation is not
going to change (esp. case for historical databases). Use edit copy,
Paste Special (as values) to do this.

Minimise colours and formatting.

 

[Charles Williams]

Columns take up more memory than rows, so the fewer columns the

better.

Are you sure about this? The last time I tested it the filesize was slightly
better for more columns and fewer rows:

see http://www.decisionmodels.com/optspeedc.htm for the test results.

But overall it made very little difference.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm