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.

In Ron's sample file, the list of picture file names is

Continue reading Show Network Pictures in Excel Workbook