Compress data in an excel sheet
 

Hi,
I have an excel worksheet which contains records of the past two years(size
40 MB). When I try to open this worksheet, it takes a real long time.Is it
possible to compress the data stored in that worksheet without modifying its
original format i.e. the column headings, fonts and cell colours so that it
does not take a long time to open the worksheet?

Compress data in an excel sheet
 

Try this first Purnima
http://www.contextures.com/xlfaqApp.html#Unused



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Purnima" wrote in message ...
Hi,
I have an excel worksheet which contains records of the past two years(size
40 MB). When I try to open this worksheet, it takes a real long time.Is it
possible to compress the data stored in that worksheet without modifying its
original format i.e. the column headings, fonts and cell colours so that it
does not take a long time to open the worksheet?

Compress data in an excel sheet
 

Nothing I know of. If anything compressing the data is going to take longer
to open becasue the data will need to be de-compressed on open. If you have
two years worth of data in a spreadsheet, it may be time to consider if a
database would work better for you. In my humble opinion when a spreadsheet
hit 40Mb it is re-evaluate.

HTH

"Purnima" wrote:

Hi,
I have an excel worksheet which contains records of the past two years(size
40 MB). When I try to open this worksheet, it takes a real long time.Is it
possible to compress the data stored in that worksheet without modifying its
original format i.e. the column headings, fonts and cell colours so that it
does not take a long time to open the worksheet?