+ Reply to Thread
Results 1 to 3 of 3

reducing size of multiple embedded graphics

Hybrid View

  1. #1
    Registered User
    Join Date
    04-22-2006
    Location
    CT
    Posts
    6

    reducing size of multiple embedded graphics

    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)

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

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

  3. #3
    Registered User
    Join Date
    04-22-2006
    Location
    CT
    Posts
    6

    size is the problem not getting the graphic into the cell

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1