Condensing Excel file size
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Condensing Excel file size

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there a way to reduce the size of an Excel file? I have a large Excel file that gets e-mailed to others daily. It contains about 3 years of history data for which I have copied-paste special-values to eliminate the formulas. The current couple of months does contain formulas. This file takes extremely long for the recipients to open because of the file size (2675 KB). Any suggestions?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I had a similar problem - I had files with very little in them which were 2M upward in memory and I didn't know why.

    So what I did was select all the rows I wasn't using from say row 150 down to 65536 and delete them. Yes, deleting blank rows from beneath your spreadsheet. Sounds weird I know but it did reduce my file space from being 2M+ to being just 200kb.

    Give it a try!

    RET79

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I agree with RET79.
    It takes file size to retain formatting information.
    If each column has it's own format, then make sure you select and format the entire column and not the individual cells. Formatting one column = one set of instructions. Formatting two cells = two sets of instructions even if the formatting is identical.
    I'm assuming that you are using a Zip utility as well? If not, use win zip or a similiar zipping utility.
    Formatting information is usually shrunken by about 80% or so.
    However, if the size of your file is a result of the hard data which it holds, there is not much you can do within Excel it'self. You would need to send your data as a csv or other type file and then update the seperate spreadsheets of other users.
    There are other options as well and perhaps more than I realize.
    Tom

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the responses! I'll see if I can do any of these things to improve the file size.
    Thanks,
    Tracy

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    Good points ther i recomend as you pates as value its kinda dead, but llok at over formatting, times i see silly formatting or that graphic.. bloat a sheet...

    Also any file needs to be Zipped, two reasons, Scripts get crunched my firewalls and also many firewalls can not look inside zip files, silly but true . also some can, need to suss it out.

    and the file size of cause, try add password.. this will make firewalls harder to access it all they can do is stop the attachment.

    BTW if just a snip of data send it raw in txt on the html RTF side of outlook this will save even more as now sheet attachment, can sent more than one email if needed and copy and paste back into excel, your be surprised it quite easy

    just some ideas... take care.
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com