+ Reply to Thread
Results 1 to 8 of 8

Excel File Became 600kb smaller?!

Hybrid View

spursrule68 Excel File Became 600kb... 07-01-2012, 06:29 AM
Andy Pope Re: Excel File Became 600kb... 07-01-2012, 06:37 AM
spursrule68 Re: Excel File Became 600kb... 07-01-2012, 06:42 AM
spursrule68 Re: Excel File Became 600kb... 07-01-2012, 06:42 AM
Andy Pope Re: Excel File Became 600kb... 07-01-2012, 06:44 AM
abousetta Re: Excel File Became 600kb... 07-01-2012, 06:44 AM
spursrule68 Re: Excel File Became 600kb... 07-01-2012, 07:19 AM
abousetta Re: Excel File Became 600kb... 07-01-2012, 11:07 AM
  1. #1
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Excel File Became 600kb smaller?!

    I just converted my 2003 file to the 2010 version, and it went from 906kb to 330kb. On the face of it I can see no differences in loss of data/functions!

    Is there a reason for this or will data have become lost somewhere? Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Excel File Became 600kb smaller?!

    the new .xlsx file format is a zipped file so you can see a reduction in file size, due to compression, for certain files.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Excel File Became 600kb smaller?!

    wait, its currently .xslm. same applies?

  4. #4
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Excel File Became 600kb smaller?!

    awesome, thanks for the reply. A much improved version then!

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Excel File Became 600kb smaller?!

    .xlsm denotes the file contains macros.

    more info on file formats.
    http://office.microsoft.com/en-gb/ex...464.aspx?CTT=1

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Excel File Became 600kb smaller?!

    all the new file types (xlsx, xlsm, xlsb, etc.) are all compressed types. xls could contain macros but xlsx cannot. That's why you would have to save as xlsm or xlsb.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  7. #7
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Excel File Became 600kb smaller?!

    excellent. thanks guys

  8. #8
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Excel File Became 600kb smaller?!

    If you are satisfied with the responses then please mark the thread as solved.

    Good luck.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1