Excel - mac - linked picture problem

Question

Hi. I have office 365 on my Mac. I'm trying to paste a linked picture in Excel but when I do it pastes the box the right size but the image inside is enlarged and I can only see the top left part of the image. I've tried everything and have searched high and low on the internet but I can't see to sort it. I tried creating some simple shapes within excel and pasting these as a linked picture and had the same problem. I did it with a table and that worked fine but anything else doesn't work. I've run out of ideas. Any help would be massively appreciated!!

I've attached a screenshot example to show what I mean.

Answer 1

I have exactly the same issue. I reported this issue to Microsoft 4 times since July 2019 with no feedback:

2x through the help improve office; once I was asked to submit an example file, but no one ever responded.

1x - directly to a Project Manager, who said he would let the Excel for Mac team know.

1x - recently to UserVoice under Excel for Mac.

https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/39663556--linked-picture

I am using version Excel 16.35 (20020507) on Insider, but every version since July has the same problem.

Linked Images is such a great feature, but it does not seem to be implemented correctly on the Mac. The image is scaled and cropped. I suspect it has something to do with the retina display expected screen resolution on the mac since it is off by about 2x. The resolution of the input file does not seem to be a factor.

Excel Mac will correctly display typed text as a named range / linked picture, just not images (jpg, png, pdf).

More info on the concept is here:

https://trumpexcel.com/picture-lookup/

Creating a new MacOS account with wholly new user preferences does not resolve anything.

Answer 2

I've tried following the instructions and going into Preferences under Excel but I can't see I have this tab. Below is a screenshot of my Preference list ...

Answer 3

Can change Image Size and Quality, in the Default resolution list, select High fidelity?

https://support.office.com/en-us/article/change...

Answer 4

Hi Will

Could you try change the screen resolution and revert it back and try?

https://www.wikihow.com/Change-the-Screen-Resol...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Also confirm you have updated to the latest office packages?

here is the link:

Automatic Update of Office

https://support.office.com/en-us/article/update...

Hi Jegan,

Thanks for the quick reply. I'd already played around with the screen resolutions - tried it on each one but no joy. I'm on automatic updates with respect to Excel but I just double checked and it says I'm on the latest version.

Any other ideas?

Thanks again.

Regards,

Will

Answer 5

Hi Will

Could you try change the screen resolution and revert it back and try?

https://www.wikihow.com/Change-the-Screen-Resol...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Also confirm you have updated to the latest office packages?

here is the link:

Automatic Update of Office

https://support.office.com/en-us/article/update...