Oct 01 2021 02:43 PM
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
Oct 01 2021 03:07 PM - edited Oct 01 2021 03:23 PM
Solution1) 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
Oct 01 2021 03:18 PM
Thank you very much for your explanation and your time, I have totally missed it out.
Thank you!
Michal
Oct 01 2021 03:07 PM - edited Oct 01 2021 03:23 PM
Solution1) 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