Inserted Photos - Enormous Excel File Size

[Guest]

Hi,

I have inserted and re-sized photos in a spreadsheet. There are (29) photos,
and there individual file sizes total 15MB. However, the saved Excel file is
442MB! The same Excel file without the inserted photos is only 28KB. I need
to be able to share this file (with the photos) with folks in other
locations. Is there some way to keep the Excel file from ballooning like
this, when photos are inserted into it? Why does the Excel file get so large?

Thank you

 

[Guest]

XL is not a graphics program and is likely not designed to deal with large
attachments.

Shrink the size of the pictures down to under 512K or so and you'll be fine.

 

[Guest]

Inserting .bmp files can result in a huge worksheet. Here is a trick:

1. save you workbok as a Web Page
2. a _File folder should be created.
3. in the folder will be your pictures in .jpg format
4. use these pictures in place of the originals

 

[Guest]

Thank you for the response. I am already using .jpg files, not .bmp's. Any
other ideas? I have seen this same file size problem with photo's inserted
into MS Word documents, too. Seems to be a problem with the way that MS
handles embedding these types of files? It seems like it would be a very
common thing to do, so there must be some "trick" that I am missing...

Steve