+ Reply to Thread
Results 1 to 2 of 2

Inserting linked images into Excel 2003 worksheet

  1. #1
    Registered User
    Join Date
    04-19-2007
    Posts
    1

    Inserting linked images into Excel 2003 worksheet

    I have a large Excel 2003 workbook that basically acts as a monthly report. This file contains several linked objects, as well as numerous references to other Excel workbooks. All of these assorted files are updated at random intervals over time. Once a month, I refresh the links in my Excel file, and save the whole thing as a PDF. This acts as a "snapshot" of the data in all the various files.

    So far, so good. Everything works just as it should.

    Now, I have been asked to include a set of images as part of this report. These images are always in the same location, are always named the same, and even always have the same pixel dimensions. However, the actual content of these images is always changing. This Excel file of mine must include a snapshot of each of these images.

    I attempted to imbed these (*.PNG) images using [Insert > Object > Create from file], making sure to check the 'link to file' checkbox. Instead of placing the image in my worksheet, Excel inserts a box with the file name...

    \1

    Am I doing this correctly? It looks like I cannot use [Insert > Picture > From File], as there is no option to link the file using this method.

    Any ideas? Thanks.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483
    Check out this site
    download the example, see if it's what you are looking for...

    http://www.mcgimpsey.com/excel/lookuppics.html

+ 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