compressing excel file.

[Nikhil2803]

Hi Team, I have an excel sheet having lots of validations using conditional formatting and VBA codes. After completion of my work, the size of excel sheet has gone to 12 MB. I tried saving in byte format and it has reduced to 7 MB now. Since, this excel sheet needs to be consumed by some other RPA tool, it needs to get reduced to approx. 1 MB. Could you help me the ways which I can use to further reduced/compress the file. Any RPA or any other methods are also welcomed. Thank you in advance.

 

[arthurbr]

try 8 Ways to Reduce Excel File Size (that actually work)

 

[Logit]

Paste the following macro into a COPY of your workbook. If it successfully reduces the workbook size, then perform same on the original workbook.

Sub LipoSuction()
'JBeaucaire (8/3/2009)
Dim LR As Long, LC As Long
Dim ws As Worksheet

For Each ws In Worksheets
    LR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row + 1
    LC = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column + 1

    'Clear everything below column A last cell and row 1 last cell
        ws.Range(ws.Cells(1, LC), ws.Cells(ws.Rows.Count, ws.Columns.Count)).Clear
        ws.Range(ws.Cells(LR, 1), ws.Cells(ws.Rows.Count, ws.Columns.Count)).Clear
Next ws

End Sub