Results 1 to 15 of 15
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crazy file size behaviour (XP)

    Hello everybody!

    I have found a phenomen without an explanation for it. I have received a xls-file from somebody else (filesize about 4 MB). Just opening and saving the file inreases the filze size dramatically (leads to 6.8 MB). Does anybody have an idea, how to prevent this, or about the reasons for it?

    Best regards,

    Porley

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

    Re: Crazy file size behaviour (XP)

    Does the workbook have Track Changes turned on (in the Tools menu)?

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

    Re: Crazy file size behaviour (XP)

    Does the file contain any macros?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    Hello Hans!
    No, Track changes is disabled. Also, I have not done any changes, just opened the file and saved it again (I tried this, because I thought this effect was caused by some other action, but it was not).

    Hello Jan Karel!
    Yes the workbook contains two user defined functions, but nothing else.

    Any ideas?

    Best regards,

    Porley

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Crazy file size behaviour (XP)

    Any pivot tables?

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    No. The map contains nothing special, only lots of data and some simple calculation. No Pivot, no filters, no groups, no ...

    Best regards, Porley

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

    Re: Crazy file size behaviour (XP)

    If you do the same when macro's are disabled, what happens to the size then?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    The same thing, file size increases dramatically.

    Best regards, Porley

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Crazy file size behaviour (XP)

    Are you both using the same version of XL?

    I assume it has "picture" in it of some sort (since you say "Map"). Perhaps 2 versions will store this picture differently, leading to the file size change...

    Steve

  10. #10
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    It is the same version of Excel (XP), only the service pack version differs: origin SP3, my version SP1. And you are right, there are two grafics in there.

    Best regards, Porley

  11. #11
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    Picking up the idea, I have deleted the pics before saving the xls-file. The result was a file of 6.5 MB size. This was not the effect.

    Best regards, Porley

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

    Re: Crazy file size behaviour (XP)

    What happens if you roundtrip the thing through html?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    OK, I have tried this:
    - saving the xls-file as html
    - opening the html-file
    - using the export to excel function
    - saving the resulting file
    Jan Karel, was that the way you were thinking of?
    This file only has 2.5 MB. After bringing the module including my user defined functions back into the excel file, the size did not change noticable. So it seems, that the trick has worked. But I onestly do not understand what happened inside excel ;-(

    Best regards, Porley

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

    Re: Crazy file size behaviour (XP)

    Almost, I would have opened the html file straight into Excel. But your trick seems to have worked.

    This is an indication that the source file may have been corrupt.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crazy file size behaviour (XP)

    Well, I have opened it into excel, but nevertheless you have to export it to excel again in order to be able to save it as a xls-file.

    Thanks for your help.

    Best regards, Porley

Posting Permissions

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