File size swelling without adding data

Question

We are having quite the problem with workbooks increasing in size without us adding data or really changing anything. One example is now at 85MB (used to be around 35MB)

I have tried to retroactively decrease the size by removing conditional formatting, clearing empty rows and columns, all the usual stuff really.

What might be the cause of this, and does anyone have tips for how we can fix it?

Thanks.

/Oliver

sergeibaklan · Answer

Hi Oliver,
&nbsp;
If you have Inquire tab in your version of the Excel you may try from here Clean Excess Cell Formatting.

deleted · Answer

Sadly, I don't have that...

sergeibaklan · Answer

It could be not activated. Try File-&gt;Options-&gt;Add-ins-&gt;select COM Add-ins (at the bottom)-&gt;Go

deleted · Answer

Okay, so I activated that and cleaned the excess formatting, although this only decreased the size by 1MB.

sergeibaklan · Answer

When it's something specific to your file. I'd try to unzip it and check if something suspicious in xml files, but that's specific work without warranty you'll find the reason.

Forum Discussion

File size swelling without adding data

5 Replies

Resources