I have a spreadsheet that I use for a fantasy golf league.
Recently I added some picture linking. Essentially my thought was that each weeke I could load in 18 pictures (1 for each hole) on an inputs tab. The display tab would then let the user pick a hole from a dropdown menu. In addition, I would also display the entire course with an overlay with some "live" statistics. The linking is accomplished through a rather conviluted in which i reference a named range which uses an INDIRECT() function on another named range. This is the only technique I was able to use to get the picture linking to work in a dynamic way.
Everything is working the way I want except that the additiona of picture links has really slowed down the speed to the spreadsheet to the point that it takes many seconds to recalculate or run the simple macro's that assist naviagation.
Having "googled" this issue it seems like there is some kind of general issue with picture linking affecting xls performance. The solutions involved VBA and I wasn't able to implemented them successfully.
All this will make more sense looking at the file, but it isis too big to upload but I'd be happy to email to anyone interested in helping. it's a nice spreadsheet otherwise that links up to the web to grab scores and rank the fantasy pool and getting this to work would be the icing on the cake.
The answer could be that picture linking slows done the worksheet no matter what but I wanted to ask the pro's on this board.
Thanks in advance for your thoughts and please message me if you'd like me to send the spreadsheet. FWIW I work in excel 2003.
Bookmarks