Forum Discussion

rachels83's avatar
rachels83
Copper Contributor
Feb 08, 2020

Issue with camera function

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/281e44b6-18f0-454f-a95b-46021ebb6da7

 

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

  • guru1177's avatar
    guru1177
    Copper Contributor

    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. 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        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.

Resources