I create a number of excel files that use a macro that places thumbnails in a column based on the name in the first column. I have to send out updates of these sheets from time to time and re-name the files with each new version.
Of course, doing so means that that thumbnails are replaced with a graphic that says "The linked image cannot be displayed. The file may have been moved..." etc. I can always re-run the macro, but that means each time a new image is stacked on top of the old image (or error message in this case). Rather than doing that, is there a way to re-link to the images? Just direct the macro to the right folder again?
Thanks!
Bookmarks