Issue with camera function

%3CLINGO-SUB%20id%3D%22lingo-sub-1162333%22%20slang%3D%22en-US%22%3EIssue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162333%22%20slang%3D%22en-US%22%3E%3CP%3EI%20made%20an%20initial%20contact%20with%20support%20but%20they%20were%20unable%20to%20help%20me.%20I%20have%20Excel%20for%20Mac%20version%2016.33.%20I%20am%20trying%20to%20use%20the%20camera%20function%20to%20place%20an%20object%20from%20one%20sheet%20onto%20another%20sheet%20in%20the%20same%20workbook.%20The%20camera%20function%20works%20great%20with%20tables%20but%20with%20graphs%2C%20I%20am%20having%20an%20issue.%20The%20issue%20is%20the%20one%20seen%20here%20in%20this%20link%20where%20the%20image%20is%20all%20zoomed%20in%20and%20funky.%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fbug-excel-mac-16111-paste-linked-picture%2F281e44b6-18f0-454f-a95b-46021ebb6da7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fbug-excel-mac-16111-paste-linked-picture%2F281e44b6-18f0-454f-a95b-46021ebb6da7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20updating%20and%20restarting%20my%20computer.%20I%20have%20tried%20putting%20the%20image%20on%20the%20same%20worksheet%20I%20took%20the%20image%20from.%20I%20have%20tried%20manually%20altering%20the%20cell%20ranges%20of%20the%20picture.%20I%20have%20tried%20messing%20with%20the%20various%20cropping%20options.%20No%20luck.%20I%20am%20hoping%20that%20there%20is%20a%20way%20to%20fix%20this%20issue.%20I%20think%20I%20am%20not%20the%20only%20one%20in%20my%20class%20having%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1162333%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162534%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F550195%22%20target%3D%22_blank%22%3E%40rachels83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20on%20a%20Mac.%20Worked%20on%20a%20similar%20issue%20recently%20on%20this%20forum.%20Noticed%20that%20the%20picture-link%20only%20took%20the%20top%20left%20quarter%20of%20the%20original%2C%20as%20shown%20in%20your%20link.%20Couldn't%20figure%20it%20out.%20Now%20I%20came%20up%20with%20a%20work%20around%20that%20may%20be%20acceptable%20until%20this%20gets%20fixed.%20And%20it's%20not%20as%20drastic%20as%20re-installing%20Office.%3C%2FP%3E%3CP%3ECreate%20four%20identically%20sized%20cells%20(i.e.%20a%202%20X%202%20range%20like%20in%20the%20picture)%20and%20place%20your%20original%20picture%20in%20the%20top%20left%20cell.%20Then%20reference%20the%20linked%20picture%20to%20those%20four%20cells.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-09%20at%2007.19.16.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169903iE22059199677E108%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-02-09%20at%2007.19.16.png%22%20alt%3D%22Screenshot%202020-02-09%20at%2007.19.16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162788%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThis%20worked!%20It%20took%20some%20futzing%20around%20but%20it%20worked!%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162810%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162810%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F550195%22%20target%3D%22_blank%22%3E%40rachels83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat!%20You%20don't%20wanna%20know%20how%20much%20%22futzing%22%20I%20did%2C%20before%20I%20cleared%20my%20mind%20and%20cooked%20up%20this%20work-around.%20I%20guess%20it's%20Mac%20specific.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162841%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162841%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20know.%20I%20futzed%20for%20several%20hours%20before%20giving%20in.%20Funny%20I%20did%20mess%20with%20some%20of%20the%20cell%20sizes%20but%20I%20had%20not%20thought%20of%20your%20workaround.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20everyone%20else%20having%20the%20issue%20in%20class%20was%20using%20a%20MAC.%20I%20am%20surprised%20such%20a%20buggy%20issue%20has%20gone%20unaddressed%20this%20long%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162853%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F550195%22%20target%3D%22_blank%22%3E%40rachels83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20this%20now%20on%20an%20old%20iMac%20(High%20Sierra%2C%2010.13.6)%20.%20No%20problems.%20Works%20perfectly.%20But%20on%20my%20MacBook%20Pro%20(late%202012)%2C%20running%20Catalina%20-%2010.15.3%2C%20it%20does%20not.%20Mmmm....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542875%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20camera%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542875%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20mac%20book%20pro.%26nbsp%3B%20In%20MS%20excel%20camera%20doesn't%20work%20properly.%26nbsp%3B%20After%20the%20selection%20of%20cells%20for%20camera%20caption%2C%20when%20I%20paste%20it%2C%20only%20part%20of%20selected%20cells%20are%20being%20pasted%20in%20an%20enlarged%20%2F%20zoom%20version.%20remaining%20camera%20captured%20portion%20doesn't%20show%20at%20all.%20Tried%20several%20ways%2C%20restrart%20etc.%2C%20seems%20there%20is%20a%20bug.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I made an initial contact with support but they were unable to help me. I have Excel for Mac version 16.33. I am trying to use the camera function to place an object from one sheet onto another sheet in the same workbook. The camera function works great with tables but with graphs, I am having an issue. The issue is the one seen here in this link where the image is all zoomed in and funky.  https://answers.microsoft.com/en-us/msoffice/forum/all/bug-excel-mac-16111-paste-linked-picture/281e...

 

I have tried updating and restarting my computer. I have tried putting the image on the same worksheet I took the image from. I have tried manually altering the cell ranges of the picture. I have tried messing with the various cropping options. No luck. I am hoping that there is a way to fix this issue. I think I am not the only one in my class having it. 

 

Thanks for your help. 

6 Replies

@rachels83 

Also on a Mac. Worked on a similar issue recently on this forum. Noticed that the picture-link only took the top left quarter of the original, as shown in your link. Couldn't figure it out. Now I came up with a work around that may be acceptable until this gets fixed. And it's not as drastic as re-installing Office.

Create four identically sized cells (i.e. a 2 X 2 range like in the picture) and place your original picture in the top left cell. Then reference the linked picture to those four cells.

Screenshot 2020-02-09 at 07.19.16.png

@Riny_van_Eekelen This worked! It took some futzing around but it worked! Thank you!

@rachels83 

Great! You don't wanna know how much "futzing" I did, before I cleared my mind and cooked up this work-around. I guess it's Mac specific.

I do know. I futzed for several hours before giving in. Funny I did mess with some of the cell sizes but I had not thought of your workaround.

 

I think everyone else having the issue in class was using a MAC. I am surprised such a buggy issue has gone unaddressed this long? 

 @Riny_van_Eekelen 

@rachels83 

Tried this now on an old iMac (High Sierra, 10.13.6) . No problems. Works perfectly. But on my MacBook Pro (late 2012), running Catalina - 10.15.3, it does not. Mmmm....

I use mac book pro.  In MS excel camera doesn't work properly.  After the selection of cells for camera caption, when I paste it, only part of selected cells are being pasted in an enlarged / zoom version. remaining camera captured portion doesn't show at all. Tried several ways, restrart etc., seems there is a bug.