Show Network Pictures in Excel Workbook

If you add pictures to an Excel workbook, the file size can increase pretty quickly. And if you’re updating the pictures occasionally, perhaps for a product catalogue, you’d have to remember to update all the Excel files that have those pictures.

Instead of adding the pictures to the Excel file, Ron Coderre has created a sample workbook that displays pictures from a network file folder or even a web folder. You can distribute Excel workbooks with links to the picture files, and that will mean smaller files, and easier updates

Enter the Picture File Info

In the Excel workbook where you want the pictures, create a list of picture names, with file path and file names in the adjacent column. In the example shown below, two files are in the C drive, and one is on the internet.

showpics00

In Ron’s sample file, the list of picture file names is in a range named LU_DisplayName. The picture names and file locations are in a range named LU_Name_FileLoc_XRef.

Select a Picture

Using data validation, Ron created a drop down list where users can select one of the picture file names. The data validation cell is named rngDisplayName.

showpics02

A VLOOKUP formula returns the location of the selected picture file, in a cell named rngFileLocation.

showpics04

The selected picture is displayed in a range named rngPicDisplayCells.

showpics03

How It Works

To make the selected picture show on the worksheet, Ron added some event code to the worksheet. When the data validation cells changes, the code runs, and shows the selected picture file.

showpics01

Detailed Instructions

In Ron’s sample file, you can view the detailed instructions for setting up the workbook and displaying the pictures. He describes the data validation setup, the named range formulas and the VBA code to make everything work.

Download the Sample File

To see how the picture display works, you can download Ron’s sample file from the Contextures website.

In the “Charts and Graphs” section, look for “RCH0002 – Insert Pictures from Folder”.

The file contains macros, so you’ll have to enable them to test the file. There are two versions of the file — one for Excel 2007 an done for earlier versions. Both sample files are zipped.

__________________

RCH0002 – Insert Pictures from Folder

You may also like...

1 Response

  1. Amber says:

    I am working on an order form for work where I am incorporating this technique. Everything seems to be working except for the picture actually showing up. I even named the ranges the same as you did. Is there anyway to send you my project and you could let me know what I am missing or doing wrong?

Leave a Reply to Amber Cancel reply

Your email address will not be published. Required fields are marked *