Picture Reference Bug

Question

I've used pictures for individual profiles in Excel for a while. I have one picture, but I want to display it in multiple places so I've just copy + pasted and changed the pasted picture's formula to a cell reference of the original picture. It's worked just fine until recently.

For some reason, now, when I change the copy + pasted picture to a cell reference that contains the original picture, it stretches the referenced picture and only displays the top-left 1/4 of the picture. I cannot figure out how to fix it and don't understand what's going on and it seems to be a bug. I don't know of any setting or anything that was changed, but some update in the past messed something up.

Here's a picture to explain what I'm talking about:

I inserted a picture into cell A1. I copy + pasted the picture into Cell B1. Looks like it should. Then, as soon as I change the formula of picture in B1 to a cell reference of A1, it distorts the picture like so.

Is there a fix for this? Is it a bug that's being worked on?

Answer 1

Here's the sample file: https://1drv.ms/x/s!AmqzA4UIaNDCgR9T2UBKuMzpA4ng

Answer 2

You can upload from Onedrive application on your computer.

If you don't have this application,

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Optional but recommended - Uncheck the Allow Editing
5. Click Get a Link.
6. Copy the link and paste the link here.

Answer 3

Okay. How can I share the sample file?

Answer 4

Before reporting this as a bug, I need to experiment and verify.

Answer 5

I can share the sample file that I took the screenshot above from.

I thought the issue was a setting I had changed, but a brand new, blank file did the same thing.