embedded graphics

[camjohnson]

I'm embedding a Corel Draw graphic (logo) in an worksheet. The
worksheet prints out two 'forms' per page each with a logo (and other
data) and there are up to 50 pages. The logo is about 150KB so that
makes the file 15MB if I 'paste' each logo into the cell. Is there
some way to insert the graphic 'once' and then refer to it indirectly
so it gets stored only once (making my file size about 100 times
smaller.
Actually this is a slight simplification because other things are
going on as well, but the file size went from less than 1MB to over
15MB due to the logo.

 

[Ed Ferrero]

Hi camjohnson,

I'm embedding a Corel Draw graphic (logo) in an worksheet. The
worksheet prints out two 'forms' per page each with a logo (and other
data) and there are up to 50 pages. The logo is about 150KB so that
makes the file 15MB if I 'paste' each logo into the cell. Is there
some way to insert the graphic 'once' and then refer to it indirectly
so it gets stored only once (making my file size about 100 times
smaller.
Actually this is a slight simplification because other things are
going on as well, but the file size went from less than 1MB to over
15MB due to the logo.

Use the camera tool to create a picture of a worksheet
range that updates in real time.
Right-click a toolbar and choose Customize from the menu
Click on the Commands Tab, choose the Tools category,
scroll down in the commands list until you see the Camera
button (it is a fair way down). Drag the Camera button
onto one of your existing toolbars.

Copy the original logo as a picture in one location of
the workbook.

Select a range that includes the loogo picture and click
the Camera button, then click somewhere on a worksheet -
the range is copied as a linked picture.

I have not tested this to see if it reduces file size
significantly. From memory it does.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com