Huhe ecel file size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would appreciate any input on this matter.

My file starts out being around 1meg just one sheet with lots of VBA code,
when I insert a userform, the file size become 19MB. There are some picuture
in the user orm, I tried them, just Still I get huge file sizes around 18M,
not sure what is taking up the space because when I compress it it become
arounf 400KB
I put a comman button "main" in the worksheet . when I click on it, it takes
a lot of time to load the userform. I don't know why?
Thank You!
 
It sounds like the picture file that you imported is the problem. High
megapixel pictures take up a lot of space, and take time to load. Try
compressing the picture separately then importing it into the userform.
 
I compressed the 3 pictures (8k each ) but it does not solve the problem.
Even I tried to remove oictures but the file is still 19 MB. I forgot to note
before that there are at least 3 spreadsheet and 3 chartspace controls in the
user form. Could that be the problem?
 
It could be. It's hard to say without testing.

One problem with Excel is that it tends to remember things, even after
they've been deleted. I would create a new workbook and userform and add the
new compressed image then save (no need to add any code) and see what the
file size is. You may want to also try with the spreadsheet and chartspace
controls.

If this makes the file smaller then you may need to rebuild the workbook.
 
Back
Top