Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Compression (XL97;SR2)

    Is it possible to compress the file size more than what you get when you save a XL file. I don't particularly want to use 3rd party software.

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File Compression (XL97;SR2)

    What do you mean by "more than what you get"? Excel doesn't particularly try to compress a workbook. You can get rid of unused styles and number formats, and empty but formatted rows and columns, but that's about it if you don't want to use WinZip or something like that...

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Compression (XL97;SR2)

    I'm afraid winzip or similar would be the only way.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Compression (XL97;SR2)

    With winzip, you can of course use the 'make .exe' option so your target wouldn't need winzip to open and read it.

  5. #5
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Compression (XL97;SR2)

    ..... and if you only want to transmit values, saving as .csv results in significant space saving (especially if you then zip it, too!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •