View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Purnima Purnima is offline
external usenet poster
 
Posts: 15
Default 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?