Large Excel File Size

  • Hi,


    I have an Excel file with two worksheets in it, where one worksheet has full of IF formulas and a Bar chart.


    The second sheet has 1 Dougnut chart and a Bar chart.


    Now my problem is, the total size of this Excel file is around 27 MB, which is huge for this as this has to be shared with different peoples for filling.


    Can anybody help to figure out the reason for file size and would appreciate it if provide a solution to reduce the size.


    Thanks in advance.

  • Hi,


    Have you tried to save your Excel file as a binary workbook with the .xslb extension ?


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi,


    Yep, I tried saving the file as a Binary workbook and it brought down the size to 3 MB.


    Thanks for your Help.


    But is it possible to reduce the size without changing the format?.