>I have a small problem with a growing Excel file. The file is about
>3.3 MB and when I ZIP it, it goes to about 495 kB. However, if I hide
>some columns and protect the work sheet, it only ZIPs to 2.8 mB.
>There shouldn't be that much code to enable the hiding and
>protection, so does anyone have any clues as to what is going on? I
>would expect the ZIPed file to be 600 to 700 kB at most.
From my experience I know that Excel is working unstable when file
size grows about 1MB (~1000 rows & ~20 columns). It's behaviour is
unpredictable. Therefore, I try don't exceed this barrier. The same
thinks happen for Access at 100Mb barrier.
--
Best regards,
Yakymakha
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://freepctech.com/pcsoft.shtml
|