Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Size Again... (Excel 97-SR2)

    I have a 5.91Mb file. No preformance issues, recalcs in under a second. Just looking for ways ro reduce file size, because we have to e-mail it around.

    Trying to highlight all worksheets and make a copy in a new workbook result in a Disk Full Error. (It isn't)

    Over to Excel 2000 SR1. File Save As works.. Export all worksheets works. The file size stays 5.91Mb. Saving as HTML results in a 28.7Kb file. Now, never having done this before, is that sort of reduction in size usual? When I re-open the HTML file and do a Save As .xls, I'm back to a 5.91Mb file. Interestingly excel complains when you re-open the HTML file that it encountered problems with the conditional formattingin the sheet.

    Any thoughts, observations?

    Regards
    Peter

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

    Re: File Size Again... (Excel 97-SR2)

    Just a general remark:

    Applying a format (or conditional format) to an entire row or column is far more (file-size-) efficient than applying it to a largish number of cells.

    Could you attach the html version here?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Again... (Excel 97-SR2)

    <P ID="edit" class=small>(Edited by j.peter.orourke on 25-Oct-02 09:32. Third attempt at attachning file...)</P>Jan Karel - File attached. Think I've changed any sensitive proprietray information. All worksheets are protected, no passwords. Several of the sheets will be hidden in the distribution model.

    Regards
    Peter
    Attached Files Attached Files

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

    Re: File Size Again... (Excel 97-SR2)

    Dunno what you did to it, but this is what I got...(after a lot of sheets listed as being missing, named Sheet001.htm, Sheet002.htm, .......)
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Again... (Excel 97-SR2)

    Hi Jan Karel

    Er thank you but..... Am confused.. Did I send youan empty file? Or have you sent me an empty file? i.e. All cell entries/formatting is now missing. Only thing here is worksheets, but all empty?

    Regards
    Peter

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

    Re: File Size Again... (Excel 97-SR2)

    I opened the html file you attached, saved as workbook, zipped and attached in my last msg.

    BTW: how large is a ZIPped version of your 6 Meg workbook?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Again... (Excel 97-SR2)

    Hi Jan Karel

    Well... the file you sent back to me has no calculations/formulas/data in it. Just the bare worksheet structure?

    The xls. version is just under 800K zipped.

    Thanks for your time on this, appreciated.

    Regards
    Peter

  8. #8
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Again... (Excel 97-SR2)

    It looks as if you only sent the front page of your html file. When you look at the source code it references 12 other sheets.
    <link id="shLink" href="./Test_files/sheet001.htm">
    <link id="shLink" href="./Test_files/sheet002.htm">
    <link id="shLink" href="./Test.................

    HTH

    Peter

  9. #9
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Again... (Excel 97-SR2)

    Hi Folks

    Ahhh THUD!.. Told you I had never done this export to HTML thing before....

    The file I sent was the file that I thought Excel 2K had exported to HTML, and which it reports as a 28K file.. What I had spotted/realised was the Test_Files directory it creates with the other 10Mb of files in. Doooooh! I had my Excel head on, and not my limited web design head - Well, that's my excuse.

    I guess this is just a big model! I need to find other ways of compressing some of my work. Apologies to anyone who has wasted their time trying to open this file.

    Regards
    Peter

Posting Permissions

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