Forum Discussion

MiBel_'s avatar
MiBel_
Copper Contributor
Oct 01, 2021
Solved

Dynamic picture

Hi all,

I have started to create a database, which should include also pictures.

I feel like I have gone through all tutorials and forms, how to do it, but I feel lost.

My problem:

When I download any document, in which is the dynamic picture working, I am able to put there other ones, also with different functions, which are being saved (Index+Match, Indirect+adress, xlookup ...)

When I do the same thing in an empty sheet, or in my database sheet, t is just not working, showing errors.

In the attachment, I send working and not working samples.

Do I miss something, or do I have some error in the setting of a document?

Thank you very much for your help

Best Regards

Michal

 

  • MiBel_ 

    1) The name not_working was not defined correctly. You should use absolute references to prevent the definition from changing depending on which cell is selected.

    2) You should select the image over G2 and set its formula to =not_working

2 Replies

  • MiBel_ 

    1) The name not_working was not defined correctly. You should use absolute references to prevent the definition from changing depending on which cell is selected.

    2) You should select the image over G2 and set its formula to =not_working

    • MiBel_'s avatar
      MiBel_
      Copper Contributor

      HansVogelaar 

      Thank you very much for your explanation and your time, I have totally missed it out. 

      Thank you!

      Michal

Resources