Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Reducing File Size

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

    Default

    I've created a very large workbook (7 MB) which incorporates numerous formulas that reference various worksheets in the same workbook. The workbook contains over 100 individual worksheets. On a daily basis, data is added to several of the "input" worksheets, and the formulas in the "output" sheets automatically create the finished product. When I'm done formatting (headers, footers, dates, bold, color, etc.) the "output" sheets I hide all of the "input" sheets and save the file and it's ready to send to the client.

    However, it's very difficult and "unprofessional" to send such large (7 MB) Excel sheets to clients via email. I've discovered the ability to convert these large files to .pdf documents and that greatly reduces the file size. This conversion process takes a lot of time though due to the large size of the workbook.

    My question: Is there any way I can dramatically reduce the size of my workbook without compromising any of the formulas I've created or deleting any of the worksheets? I need to find a way to make these worksbooks more manageable and easier to send via email.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried WinZip?

    I had a 1.3MB workbook that I reduced to 202k.

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

    Default

    A trick that I learned for the excel file itself, is to begin at the first worksheet. and actually delete all columns and rows outside of the data area.

    For example if worksheet A's data area is
    A1-j40
    Click on row 41 hold down control-end-(down arrow) then alt-e, delete
    Also click column k hold down control-end-(down arrow) then alt-e, delete.

    Continue this process for all your worksheets (tedious, but the process works)

    I reduced a file size of over 4meg to 1.5meg by using this procedure.

    Hope this helps.
    -Dave

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

    Default

    I was hoping that there was a way to somehow eliminate the formulas in the finished product and just have the values inserted. Is there any way I can quickly replace all of the formulas in my output sheets with only the values. I know this can be done with a Paste Special but that would be very time consuming as well.


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

    Default

    if pates special is reqd copy all and P S


    Free Excel based Web Toolbar available here.

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

Some videos you may like

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
  •