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


--
camjohnson
------------------------------------------------------------------------
camjohnson's Profile: http://www.excelforum.com/member.php...o&userid=33751
View this thread: http://www.excelforum.com/showthread...hreadid=535271

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


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535271

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?


--
camjohnson
------------------------------------------------------------------------
camjohnson's Profile: http://www.excelforum.com/member.php...o&userid=33751
View this thread: http://www.excelforum.com/showthread...hreadid=535271