Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to compress photos in an excel worksheets | Excel Discussion (Misc queries) | |||
How can I shrink or compress excel document | Excel Discussion (Misc queries) | |||
Compress big Excel file | Excel Discussion (Misc queries) | |||
Compress picture with macro in Excel | Excel Programming | |||
Compress Excel File Format? | Excel Programming |