Hi All,

My first post here, so be gentle =)

I've been working on a excel sheet, where I need to have +500 pictures changing according to user input.
Until now, I have used named views, and it works fine with a few, but going up to 500, I would like to have pictures external and in a relative path besides the workbook.

I found how to link an external picture, but can't see how to get it to change. Also I would avoid using VBA/macro since we need to send this to customers who don't want to enable macros.
Is this possible? We are using office 365/2016..

Thanks in advance.!

Regards,
Flemming