Excel File size, when imported JPG images

G

G

Hi, I am trying to import JPG images in to an Image control
I have in my excel sheet. Even though the JPG is 60 KB in
size, when I import the image and save my excel, excel size
grows exponentially, to 4 MB. When I have 600 KB JPG, excel
size went to 17 MB. Can you tell if there is any way to
avoid this problem, why is this happening, is there any
property in the image control which can help to solve the
problem?

TIA
-G
 
G

Greg Koppel

Do you have to use the Image control? When importing a 50 KB image, I end
with a 60 KB file with out the Image control versus 900 KB with the control.
 
J

Jon Peltier

I don't know if this is related, because it's independent of using Image
controls. In Excel 97 if you paste an image from an image editor, even
if it was a small JPG file, it would be pasted as a full bitmap. If you
use the Insert > Picture and browse to the image file, you only add as
much to the workbook as the size of the image file. I don't know if it's
the same in later versions, because I don't work with images in the
worksheets much any more.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top