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,

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?.

Thank You