Excel - Images -

%3CLINGO-SUB%20id%3D%22lingo-sub-1176259%22%20slang%3D%22en-US%22%3EExcel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176259%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20help%20on%20fixing%20a%20graphics%20issue%20with%20images%20that%20are%20used%20in%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20the%20issue%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20a%20simple%20formula%20to%20look%20up%20and%20get%20an%20image.%20however%20my%20original%20image%20that's%20in%20the%20cell%20is%20clean%20and%20clear%20with%20no%20bounding%20box.%20When%20the%20formula%20runs%2C%20it%20returns%20the%20new%20image%20with%20a%20bounding%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20not%20matter%20too%20much%20if%20it%20was%20on%20a%20white%20background%2C%20however%2C%20the%20image%20is%20in%20a%20colored%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20images%20results%20below%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%22Bounding%20Box%20Issue.jpg%22%20style%3D%22width%3A%20310px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171431i81ADD6360A1EBE67%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Bounding%20Box%20Issue.jpg%22%20alt%3D%22Bounding%20Box%20Issue.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176259%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176409%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176409%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559525%22%20target%3D%22_blank%22%3E%40Dmichaud65%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20could%20share%20your%20formula%20or%20a%20sample%20workbook%20to%20facilitate%20testing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177478%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177478%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559525%22%20target%3D%22_blank%22%3E%40Dmichaud65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20procedure%3C%2FP%3E%3CP%3EHope%20this%20helps%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%22Dmichaud65_0-1581947889330.png%22%20style%3D%22width%3A%20326px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171482iAFFCBF774AE35EAC%2Fimage-dimensions%2F326x537%3Fv%3D1.0%22%20width%3D%22326%22%20height%3D%22537%22%20title%3D%22Dmichaud65_0-1581947889330.png%22%20alt%3D%22Dmichaud65_0-1581947889330.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177568%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177568%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559525%22%20target%3D%22_blank%22%3E%40Dmichaud65%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20repeated%20your%20steps%20with%20a%20different%20image%20and%20cannot%20duplicate%20the%20grey%20border.%20Could%20you%20please%20share%20your%20sample%20file%20so%20that%20I%20can%20test%20this%20issue%20further%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184224%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%3C%2FP%3E%3CP%3Ebut%20I%20found%20the%20answer%2C%20while%20I%20was%20writing%20this%20to%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20it%20with%20an%20image%20that%20has%20transparency.%20100%25%20you%20will%20see%20the%20bounding%20box.%20its%20looks%20like%20its%20carring%20over%20the%20cell%20grid.%20OMG!%20what%20a%20thought.%20I%20went%20to%20view%20and%20removed%20show%20gridlines%20and%20Perfect!%20no%20more%20white%20frames.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184446%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Images%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559525%22%20target%3D%22_blank%22%3E%40Dmichaud65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWonderful!%20I'm%20glad%20you%20found%20a%20solution!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I'm looking for help on fixing a graphics issue with images that are used in formulas.

 

here is the issue,

 

I am using a simple formula to look up and get an image. however my original image that's in the cell is clean and clear with no bounding box. When the formula runs, it returns the new image with a bounding box.

 

This would not matter too much if it was on a white background, however, the image is in a colored cell. 

 

Any help would be appreciated

 

See images results below

 

Bounding Box Issue.jpg

5 Replies
Highlighted

Hello @Dmichaud65,

 

Perhaps you could share your formula or a sample workbook to facilitate testing?

Highlighted

@Dmichaud65 

Here is the procedure

Hope this helps

 

Dmichaud65_0-1581947889330.png

 

Highlighted

Hello @Dmichaud65,

 

I have repeated your steps with a different image and cannot duplicate the grey border. Could you please share your sample file so that I can test this issue further?

Highlighted

@PReagan 

Thanks for the help

but I found the answer, while I was writing this to you.

 

Try it with an image that has transparency. 100% you will see the bounding box. its looks like its carring over the cell grid. OMG! what a thought. I went to view and removed show gridlines and Perfect! no more white frames.

 

Thanks for the help

 

 

Highlighted

@Dmichaud65 

 

Wonderful! I'm glad you found a solution!