Embedded Objects make the file large

blueturtle

New Member
Joined
Aug 13, 2004
Messages
11
Hello there

I've created one of those picture quizzes in Excel (in my lunch hour!) where you type in your answer and it tells you if you are correct or not. I have embedded 100 bmp images. The file is now 46MB, takes a while to save and I can't email it to anyone (the network rejects it).

Have I created a monster?

Does anyone know about embeding objects and what to do about the file size please? Come to think of it, I've actually copied and pasted most of the images in, and then re-sized them. Is this where I have gone wrong?

Thank you in anticipation.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Consider replacing uncompressed BMPs with compressed JPGs or GIFs or PNGs.

You may also want to create links to the pictures. Or create a single shape (from the Drawing toolbar) and change that shape's UserPicture property through VBA. Of course, if you use links the combination of the standalone images and the XL file will be huge unless you reduce the size of each image. Effectively, you are back at para 1 above.
 

blueturtle

New Member
Joined
Aug 13, 2004
Messages
11
Thank you for your help. I've just re-saved one image as a jpeg and the file size went from 106kb to 8kb. So I thinks that's my manswer. Again, thanks.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
You are welcome.

If you use JPG make sure that the compression does not degrade the quality of the image. JPG can compress a file to a smaller or larger degree and the greater the compression the more degraded the final image.
 

dave_f

New Member
Joined
Jul 17, 2007
Messages
33
Hi Everyone, I could use some help on this topic.

When I insert a 57K .jpg file into an excel sheet via going insert->picture->from file it blows the size of an empty excel workbook up from 18K to 1.7megs. Any ideas on what might be causing this? I've tried using the picture options compress thing within excel but it doesn't really do much to reduce the size. 1.7 megs down to 1.65.

I'm using excell 2003.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,798
Messages
5,574,372
Members
412,589
Latest member
ArtBOM
Top