ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel File size, when imported JPG images (https://www.excelbanter.com/excel-programming/291522-excel-file-size-when-imported-jpg-images.html)

G[_5_]

Excel File size, when imported JPG images
 
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

Greg Koppel

Excel File size, when imported JPG images
 
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.


"G" wrote in message
...
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




Jon Peltier

Excel File size, when imported JPG images
 
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

G wrote:

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




All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com