Make a Reference to a "Defined Name" of a Workbook from another Workbook|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello,

I'd like to select Pictures according to a slicer selection. I have 2 files: 1 "reporting file" where there is the slicer and the final reports (including about 20 pictures) and the "pictures file" with all the pictures (about 2000).

To avoid that the "reporting file" would become too big in size (by containing all the pictures), I'd like to store the pictures in a separated file. All of them being in a unique cell with a unique defined name. 

To select the right picture (according to the slice selection), I wanted to make reference to a "defined name" in the "pictures file".

From what I understood, it's not possible to make a reference to a "defined name" from another workbook.

Am I right? If yes, do you see other means to deal with this topic?

Warmly

Fred