reducing size of multiple embedded graphics

[camjohnson]

I use Excel to generate signs with some common data. The common dat
includes a Corel Draw graphic about 150KB in size. Since it is use
100 times that makes my file quite large to save. Is there a way t
embed it once and then use an indirect reference for all othe
entries?
I embedded the graphic in cell A2 (along with text) and then in cell
A6, A10, etc. tried the function "=A2" but it only copied the 'text' bu
not the graphic. Naturally I can 'paste' the graphic into each cell bu
then my file is more than 15MB in size (100 copies of the same graphic

 

[mrice]

If you refer to the graphic by its name (e.g. picture1) instead of its
location, this should help.

 

[camjohnson]

The actual reference is: =EMBED("CorelDRAW.Graphic.12","")

which refers to the picture name as you suggested. This gets the
graphic into the cell but does nothing for reducing the file size.
Each cell it is used in has the same reference and it is 'stored' in
that cell not 'referenced' to some common location, so the file size
increases each time you paste it into a cell.
This is a direct insertion not a reference to an image in a common
location as is possible in other programs.

For example: When creating a webpage (Microsoft Frontpage) there is an
'images' directory and your images or graphics are located in a common
location. If you use them 100 times in different places on your
website, your website size isn't any larger (or only minimally due to
the text of the reference) since it just calls the graphic from the
'image' directory instead of storing the same image 100 times. Is
there something equivalent in Excel where I can indirectly reference
the graphic and have it stored only in one place?