sudden increase in file size

**hk4kim** · 07-05-2013, 11:58 AM

Hi, i have posted the two files that pretty much contains the same data but one is only 300kb and the other one goes up to 800kb. I was wondering if someone can help reduce the file size(possibly the vba is causing this?)

Also, it takes much longer to open the 800kb one than the other one...

I have deleted the first few columns blank but they are only supposed to go down to row 200ish.
Password is veronica.

Help is appreciated.

**Sam Capricci** · 07-05-2013, 12:16 PM

Just a thought and I don't know what you've written in the VBA but I have found that more formulas will increase my file size quickly. In fact I found that if I write a formula like:
=if(iserror(vlookup(a2,sheet1!b2:E10000,3,false),"",(vlookup(a2,sheet1!b2:E10000,3,false)
adds more file size than just writing it as:
=iferror(vlookup(a2,sheet1!b2:E10000,3,false),"").

**XOR LX** · 07-05-2013, 12:25 PM

Hi,

No formulas present. Conditional Formatting ranges identical in each sheet. Last cell no problem in either. Nothing in Name Managers.

Can only suspect it's something to do with the code, though there I'm not much of an expert, I'm afraid.

Regards

**hk4kim** · 07-05-2013, 02:15 PM

Just to add on, when i switch the file format to xlsm or xlsb they seem to open up right away. But with the xls format the larger file takes ages to open .

**Ercan Albak** · 12-18-2013, 08:42 AM

Tried saving file as xlsb and size dropped to 7,924KB from 18,149KB and is better. But, when saved as xlsm size got lager to 18,151KB, not much 2KB more than before. On the other hand deleting pivot tables (only 2 were in) didn't change the size a lot, just 120KB. Will try to downsize the file and inform accordingly. Anyway, thank you very much.