Home

File size swelling without adding data

Deleted
Not applicable

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

5 Replies

Hi Oliver,

 

If you have Inquire tab in your version of the Excel you may try from here Clean Excess Cell Formatting.

Sadly, I don't have that...

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

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

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.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies