SOLVED

Dynamic picture

%3CLINGO-SUB%20id%3D%22lingo-sub-2804328%22%20slang%3D%22en-US%22%3EDynamic%20picture%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804328%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20have%20started%20to%20create%20a%20database%2C%20which%20should%20include%20also%20pictures.%3C%2FP%3E%3CP%3EI%20feel%20like%20I%20have%20gone%20through%20all%20tutorials%20and%20forms%2C%20how%20to%20do%20it%2C%20but%20I%20feel%20lost.%3C%2FP%3E%3CP%3EMy%20problem%3A%3C%2FP%3E%3CP%3EWhen%20I%20download%20any%20document%2C%20in%20which%20is%20the%20dynamic%20picture%20working%2C%20I%20am%20able%20to%20put%20there%20other%20ones%2C%20also%20with%20different%20functions%2C%20which%20are%20being%20saved%20(Index%2BMatch%2C%20Indirect%2Badress%2C%20xlookup%20...)%3C%2FP%3E%3CP%3EWhen%20I%20do%20the%20same%20thing%20in%20an%20empty%20sheet%2C%20or%20in%20my%20database%20sheet%2C%20t%20is%20just%20not%20working%2C%20showing%20errors.%3C%2FP%3E%3CP%3EIn%20the%20attachment%2C%20I%20send%20working%20and%20not%20working%20samples.%3C%2FP%3E%3CP%3EDo%20I%20miss%20something%2C%20or%20do%20I%20have%20some%20error%20in%20the%20setting%20of%20a%20document%3F%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3EMichal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2804328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2804377%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20picture%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172689%22%20target%3D%22_blank%22%3E%40MiBel_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20Th%20name%20not_working%20was%20not%20defined%20correctly.%20You%20should%20use%20absolute%20references%20to%20prevent%20the%20definition%20from%20changing%20depending%20on%20which%20cell%20is%20selected.%3C%2FP%3E%0A%3CP%3E2)%20You%20should%20select%20the%20image%20over%20G2%20and%20set%20its%20formula%20to%20%3Dnot_working%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

2 Replies
best response confirmed by MiBel_ (New Contributor)
Solution

@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

@Hans Vogelaar 

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

Thank you!

Michal