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?