Excel - Image Disappearing

%3CLINGO-SUB%20id%3D%22lingo-sub-3357480%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385723%22%20target%3D%22_blank%22%3E%40EhrenJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20images%20are%20probably%20only%20dependent%20on%20the%20cell%20position.%3CBR%20%2F%3EFor%20a%20filter%2C%20the%20images%20must%20be%20dependent%20on%20cell%20position%20and%20size.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EProcedure%3A%3C%2FP%3E%3CP%3ESelect%20all%20images%20-%20format%20graphic%20-%20properties%20-%20dependent%20on%20cell%20position%20and%20size%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362337%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362337%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3EThese%20are%20the%20properties%20of%20the%20images%20in%20which%20I%20have%20%22Move%20and%20size%20with%20cells%22%20selected%20(highlighted%20in%20yellow)%20which%20is%20perhaps%20what%20you%20are%20talking%20about%20when%20you%20say%20%22images%20must%20be%20dependent%20on%20cell%20position%20and%20size%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Image%20Propoerties.png%22%20style%3D%22width%3A%20189px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371059iDA4B4175D69F01FB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Image%20Propoerties.png%22%20alt%3D%22Image%20Propoerties.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFiltering%20the%20data%20works%20fine%2C%20the%20images%20act%20as%20text%20when%20filtering%2C%20however%20when%20I%20want%20to%20delete%20the%20rows%2C%20for%20example%3A%20all%20except%201's%20from%20column%20A%20using%20a%20filter%2C%20then%20un-filtering%20column%20A%20to%20show%20what%20is%20left%20(which%20would%20be%20the%202's)%20the%20images%20corresponding%20for%20each%20rows%20for%20those%202's%20disappear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362425%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385723%22%20target%3D%22_blank%22%3E%40EhrenJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20cannot%20understand%20your%20plan%2C%20my%20knowledge%20is%20not%20so%20well%20developed%20that%20I%20can%20infer%20your%20plan%20from%20the%20picture%20and%20your%20text.%3CBR%20%2F%3EIt%20would%20be%20an%20advantage%20to%20let%20us%20know%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2C%20possibly%20also%20the%20image%20format.%3CBR%20%2F%3EAt%20the%20same%20time%2C%20I%20recommend%20including%20a%20file%3C%2FP%3E%3CDIV%20class%3D%22%22%3E(Drag%20and%20drop%20here%20or%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F146099%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efiles%20to%20attach%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EMaximum%20size%3A%2071%20MB%20%E2%80%A2%20Maximum%20attachments%20allowed%3A%205)%3C%2FDIV%3E%3CP%3E...or%20pictures%20that%20can%20show%20what%20you%20intend%20to%20do.%3C%2FP%3E%3CP%3EBased%20on%20this%20file%2Fimage%2C%20you%20explain%20your%20project%20step%20by%20step%2C%20so%20you%20can%20come%20up%20with%20a%20solution%20much%20faster%20and%20more%20accurately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20understanding%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362503%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362503%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20quick%20reply%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%2C%3CBR%20%2F%3EI%20tried%20doing%20the%20same%20procedure%20just%20today%20and%20for%20some%20reason%2C%20excel%20just%20decided%20to%20work%20properly.%20My%20issue%20is%20now%20fixed.%20Thank%20you%20so%20much%20for%20taking%20your%20time%20to%20try%20and%20help%20me%20solve%20my%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20edited%20the%20post%20so%20perhaps%20you%20can%20have%20a%20better%20idea%20of%20the%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349620%22%20slang%3D%22en-US%22%3EExcel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349620%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20trouble%20with%20excel%20with%20images.%3C%2FP%3E%3CP%3EScenario%3A%3C%2FP%3E%3CP%3ELet's%20say%20I%20have%202%20columns%2C%20column%20A%20consists%20of%20'1'%20and%20'2'%20at%20random%2C%20column%20B%20consists%20of%20random%20images.%3C%2FP%3E%3CP%3EI%20have%20the%20image(s)%20properties%20as%20%22Move%20and%20size%20with%20cells%22%20to%20allow%20proper%20filtering%2C%20now%20my%20issue%20is%20that%20when%20I%20filter%20column%20A%20with%20only%201's%2C%20and%20select%20these%20rows%20and%20delete%20the%20rows%2C%20then%20un-filtering%20it%20to%20show%20what%20was%20left%20behind%20(the%202's)%2C%20the%20images%20correlated%20to%20the%202's%20disappear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20get%20a%20better%20understanding%20of%20the%20issue...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20it%20looks%20like%20unfiltered%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EhrenJ_0-1652333509263.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371078i1BE1325B469CD449%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EhrenJ_0-1652333509263.png%22%20alt%3D%22EhrenJ_0-1652333509263.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20remove%20all%20the%20rows%20with%202's%20in%20column%20A%2C%20so%20I%20would%20filter%20'2'%20and%20leave%20out%20'1'%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EhrenJ_1-1652333633854.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371088i15475A0C8DCB0940%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EhrenJ_1-1652333633854.png%22%20alt%3D%22EhrenJ_1-1652333633854.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EhrenJ_2-1652333642125.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371089iE4E8A16C6926714B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EhrenJ_2-1652333642125.png%22%20alt%3D%22EhrenJ_2-1652333642125.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20would%20select%20these%20rows%20and%20delete%20them%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EhrenJ_3-1652333727416.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371090i34210C5C9AF87A5D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EhrenJ_3-1652333727416.png%22%20alt%3D%22EhrenJ_3-1652333727416.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20I%20delete%20these%20rows%2C%20I%20will%20be%20left%20with%20the%201's%2C%20however%2C%20once%20I%20unfilter%20column%20A%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20images%20for%20the%201's%20disappear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20I%20tried%20the%20same%20procedure%20the%20next%20few%20days%20and%20it%20is%20now%20suddenly%20working%20properly...%20weird.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3349620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Image%20Disappearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385723%22%20target%3D%22_blank%22%3E%40EhrenJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20feedback%20and%20the%20images.%3C%2FP%3E%3CP%3EThat's%20where%20murphy's%20law%20crept%20in%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%3EI'm%20glad%20that%20your%20problem%20has%20been%20fixed%20and%20I%20wish%20you%20continued%20success%20with%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I am having trouble with excel with images.

Scenario:

Let's say I have 2 columns, column A consists of '1' and '2' at random, column B consists of random images.

I have the image(s) properties as "Move and size with cells" to allow proper filtering, now my issue is that when I filter column A with only 1's, and select these rows and delete the rows, then un-filtering it to show what was left behind (the 2's), the images correlated to the 2's disappear.

 

Any ideas?

 

Thanks!

 

To get a better understanding of the issue...

 

This is how it looks like unfiltered

 

EhrenJ_0-1652333509263.png

 

I want to remove all the rows with 2's in column A, so I would filter '2' and leave out '1',

 

EhrenJ_1-1652333633854.pngEhrenJ_2-1652333642125.png

 

Then I would select these rows and delete them

 

EhrenJ_3-1652333727416.png

 

Once I delete these rows, I will be left with the 1's, however, once I unfilter column A,

 

The images for the 1's disappear.

 

EDIT: I tried the same procedure the next few days and it is now suddenly working properly... weird.

 

 

5 Replies

@EhrenJ 

The images are probably only dependent on the cell position.
For a filter, the images must be dependent on cell position and size.


Procedure:

Select all images - format graphic - properties - dependent on cell position and size

 

Hope I could help you with these information.

 

NikolinoDE

I know I don't know anything (Socrates)

 

 

Thanks for your response @NikolinoDE ,

These are the properties of the images in which I have "Move and size with cells" selected (highlighted in yellow) which is perhaps what you are talking about when you say "images must be dependent on cell position and size"

 

Image Propoerties.png

 

Filtering the data works fine, the images act as text when filtering, however when I want to delete the rows, for example: all except 1's from column A using a filter, then un-filtering column A to show what is left (which would be the 2's) the images corresponding for each rows for those 2's disappear.

 

@EhrenJ 

Unfortunately, I cannot understand your plan, my knowledge is not so well developed that I can infer your plan from the picture and your text.
It would be an advantage to let us know your Excel version, operating system, storage medium, possibly also the image format.
At the same time, I recommend including a file

(Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5)

...or pictures that can show what you intend to do.

Based on this file/image, you explain your project step by step, so you can come up with a solution much faster and more accurately.

 

Thank you for your patience and understanding

Thanks for the quick reply @NikolinoDE,
I tried doing the same procedure just today and for some reason, excel just decided to work properly. My issue is now fixed. Thank you so much for taking your time to try and help me solve my problem.

I edited the post so perhaps you can have a better idea of the problem.

Thanks!

@EhrenJ 

Thank you for your feedback and the images.

That's where murphy's law crept in

I'm glad that your problem has been fixed and I wish you continued success with Excel.