Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Why size of files getting larger

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have two Excel/Macro files that are almost identical in content (sheets, modules, code etc) but very different in size. One is 815KB, the second is 1490KB.

    Can anyone tell me some factors that may influence the size of macro/Excel files. I know that with VB exe files they can grow with use and sometimes need to be recompiled to make them smaller.

    Is this a similar thing with Excel/Macro files? Are there any other reasons files may grow with use? Other than the forms, sheets and modules could there be other reasons one file is so much bigger than the other?

    Any ideas orsuggestions would be greatly appreciated

    Thanks

    voodoo


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

    Default

    Depends on what kind of info is being entered? Also depends on which programed is used more.

  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

    Hi

    To format an entire column uses the same amount of "instructions file space" as to format one cell

    If you are copying and pasting formats in seperate cells, this can increase the size of your file significantly.

    Tom

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

    Default

    I had this problem befor with a large Workbook linked to an outside Database. Trick was to go into Tools>Options>Calculation and Uncheck "Save External Link Values". This cut my file size down to about 1/3 the original. Another thing you can check is highlight/select all cells below and to the right of your work area and do a delete. This will ensure there isn't any stray formatting and data.

    Waxaholic

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the ideas axaholic I give them a try.

    Cheers

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
  •