Insert Picture from File increases Excel File Size more than the picture you inserting - WHY????

neib188

New Member
Joined
Apr 8, 2008
Messages
11
I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB - why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Willem!

Board Regular
Joined
Mar 6, 2009
Messages
139
Hi,

The bloat you're experiencing is perfectly normal. Inserting images into your sheet causes the Excel-file to increase in size more than the size of the picture itself.

Workaround: store your picture not in the Excel-file, but external (e.g. pics-folder) and link to them via VBA or something...

Check out this previous discussion:

http://www.mrexcel.com/forum/showthread.php?t=77483

HTH!
thumbup.gif
 

neib188

New Member
Joined
Apr 8, 2008
Messages
11
I was wanting to distibute just the spreadsheet to my customers and thats why I wanted the images embedded - thanks though....
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,056
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Have you tried compressing them after inserting them?
 

neib188

New Member
Joined
Apr 8, 2008
Messages
11

ADVERTISEMENT

The images were compressed in Photoshop before inserting them into Excel so excel does not really compress them much more than they already are....
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,056
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Then you are out of luck I suspect. I just inserted a 30KB gif file into a workbook and the file size grew by about 30KB so I can't really say for sure why you are experiencing that much bloat, but you could just distribute the images with the workbook as separate files?
 

neib188

New Member
Joined
Apr 8, 2008
Messages
11

ADVERTISEMENT

Not sure why either - I inserted a 8KB Gif and the file grew by 55KB - I reckon HTML is the way to go with this price list....
 

neib188

New Member
Joined
Apr 8, 2008
Messages
11
PNG and JPG's are even worse - they grow the excel file more than the GIF's.....
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,056
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Which version of Excel are you using, incidentally?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,841
Members
413,944
Latest member
3xc3ln00b

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top