how show image on a cell from a local jpg file

%3CLINGO-SUB%20id%3D%22lingo-sub-1378167%22%20slang%3D%22en-US%22%3Ehow%20show%20image%20on%20a%20cell%20from%20a%20local%20jpg%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378167%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20in%20advance%20for%20your%20interest%20in%20helping.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20to%20show%20a%20certain%20jpg%20image%20on%20a%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20said%20jpg%20will%20be%20pointing%20to%20a%20specific%20file%20in%20my%20local%20drive.%3C%2FP%3E%3CP%3Ethis%20is%20what%20stumbles%20me%3A%20i%20need%20the%20image%20to%20automatically%20change%20whenever%20i%20update%20the%20jpg%20file%20it%20is%20pointing%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20set%20an%20example%3A%3C%2FP%3E%3CP%3Elet's%20say%20i%20have%20a%20cell%20that%20shows%20a%20picture%20of%20an%20employee.%3C%2FP%3E%3CP%3Ewhen%20the%20employee%20sends%20a%20new%20picture%2C%20i%20would%20like%20to%20overwrite%20the%20old%20jpg%20file%20with%20the%20new%20one%2C%20and%20the%20excel%20cell%20will%20automatically%20show%20the%20new%20picture.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%2C%20thank%20you%20so%20much%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1378167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1383832%22%20slang%3D%22en-US%22%3ERe%3A%20how%20show%20image%20on%20a%20cell%20from%20a%20local%20jpg%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1383832%22%20slang%3D%22en-US%22%3E%3CP%3E30%20views%20with%20no%20replies.%26nbsp%3B%20does%20this%20mean%20it%20can't%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1384052%22%20slang%3D%22en-US%22%3ERe%3A%20how%20show%20image%20on%20a%20cell%20from%20a%20local%20jpg%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1384052%22%20slang%3D%22en-US%22%3ETo%20the%20best%20of%20my%20knowledge%2C%20it%20doubt%20the%20possibility%20of%20what%20you%20intend%20to%20do..%20Though%2C%20it%20might%20be%20possible%20will%20using%20VBA%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1387763%22%20slang%3D%22en-US%22%3ERe%3A%20how%20show%20image%20on%20a%20cell%20from%20a%20local%20jpg%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387763%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B!!!%3C%2FP%3E%3CP%3Ei%20was%20a%20hoping%20an%20excel%20formula%20will%20be%20able%20to%20do%20it.%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3Ebeing%20an%20intermediate%20excel%20user%2C%20i%20try%20to%20stay%20away%20from%20VBA.%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eagain%2C%20thank%20you%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

thank you in advance for your interest in helping.

 

i need to show a certain jpg image on a cell. 

the said jpg will be pointing to a specific file in my local drive.

this is what stumbles me: i need the image to automatically change whenever i update the jpg file it is pointing to.

 

to set an example:

let's say i have a cell that shows a picture of an employee.

when the employee sends a new picture, i would like to overwrite the old jpg file with the new one, and the excel cell will automatically show the new picture.

 

Again, thank you so much for your help.

 

3 Replies
Highlighted

30 views with no replies.  does this mean it can't be done?

To the best of my knowledge, it doubt the possibility of what you intend to do.. Though, it might be possible will using VBA
Highlighted

thank you @Abiola1 !!!

i was a hoping an excel formula will be able to do it. 

being an intermediate excel user, i try to stay away from VBA. 

 

again, thank you much!