Excel compact or compress utility?

5 pts.
Tags:
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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:
    report
  • 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:
    report
  • 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:
    report
  • 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:
    report
  • 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
                oSheet.Select
                ActiveSheet.UsedRange
            Next oSheet
            For Each oName In ActiveWorkbook.Names
                If InStr(1, oName, "REF!") > 0 Then
                    Debug.Print oName.Name
                    oName.Delete
                End If
            Next oName
    XIT:
            Exit Sub
    XERR:
            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:
    report
  • 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:
    report
  • 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:
    report
  • Mfzaman
    I am using an excel 2010 format its size is 210 mb I want to compress the size. Any help
    10 pointsBadges:
    report
  • Arch4ngel
    Try 7zip if you are compressing a file.
    250 pointsBadges:
    report
  • Arch4ngel
    I read from another thread that you rebuild your excel workbook using a script. Google search compact excel.
    250 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following