Excel compact or compress utility?

5 pts.
Microsoft Excel
Microsoft Office
Microsoft Access has a repair and compact utility built into it. I'm looking for something similar for Microsoft Excel -- mostly to reduce the size of bloated spreadsheets. Any suggestions (other than manually copying the important data from the large spreadsheet to an empty and clean new spreadsheet).

Answer Wiki

Thanks. We'll let you know when a new response is added.

My company uses Xshrink and it works well. The program claims it shrinks excel files to 95% we find it does about 20-30% which works for me. The free trial can be found here and the full version will run you about $60.

If anyone has a FREE solution I would love to hear about it.

I think winzip,alzip etc are the best compression utility and it can be downloaded easily also free of charge to use…

Discuss This Question: 11  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • HCream
    If you're planning to upgrade to Office 2007, you would be pleased to learn that the new Excel file format is more compact. It uses Zip file compression so spreadsheet files are smaller(as much as 75% smaller than their original size). The new file format uses a new file extension .xlsx instead of the old .xls.
    1,250 pointsBadges:
  • Buddyfarr
    KarlG - what version of office is your company using? if not 2007 I wonder if Xshrink will work with it and if it would give even more compaction to the newer format?
    6,850 pointsBadges:
  • Msame
    I had a problem with a large sheet which had somehow hit 50MB in size (mainly due to lazy formatting/highlighting I think). I found this website with instructions for installing a short VBA macro. The macro reduced the sheet to 550K! It's tested against Excel 2002
    10 pointsBadges:
  • CompressExcel
    Hi Friends, This is Sekhar from Tata. I have an Excel File with 1000+ Sheets which was around 120 MB i want to compress it to lesser size. If any of you are aware of it please reply or send a mail to Sekharvvr@gmail.com Thank you.
    10 pointsBadges:
  • MelanieYarbrough
    Hi CompressExcel, Please start a new thread for your question to keep this thread from getting off track or confusing. We discourage including your email address to avoid spamming; you will be contacted when answers to your question are posted. Thank you!
    6,345 pointsBadges:
  • Wrigax
    I have a need and looked around for something to tidy up my excel. Didn't see the sort of thing I wanted so may I offer a bit of code that may help some people. [Excel 2003] -----
    Public Sub SqueezeXL()
    Dim oSheet As Worksheet
    Dim oName As Name
        On Error GoTo XERR
            For Each oSheet In ActiveWorkbook.Sheets
            Next oSheet
            For Each oName In ActiveWorkbook.Names
                If InStr(1, oName, "REF!") > 0 Then
                    Debug.Print oName.Name
                End If
            Next oName
            Exit Sub
            Debug.Print Err.Description
    End Sub
    Note: You do need to select oSheet to use 'UsedRange' -> reduced my filesize by about 20-25%
    10 pointsBadges:
  • Storey
    HCream's solution is great. I had a flie in Excel 2003 that was 195MB. Once I saved as an Excel 2007 file, it shrunk to 7.81MB. Great solution!!!! Thanks!!!!
    10 pointsBadges:
  • Smileplease123
    Hi i have using excel 2003 version i have already create a formula for 1 to 10tabs in that tabs is a pass(1-10) that time and another result also shows a pass result how to create a this formula
    10 pointsBadges:
  • Mfzaman
    I am using an excel 2010 format its size is 210 mb I want to compress the size. Any help
    10 pointsBadges:
  • Arch4ngel
    Try 7zip if you are compressing a file.
    250 pointsBadges:
  • Arch4ngel
    I read from another thread that you rebuild your excel workbook using a script. Google search compact excel.
    250 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: