Share via

Picture Reference Bug

Anonymous
2018-03-22T02:36:37+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-03-22T05:09:06+00:00

    If your sheet is not having confidential data, could you share through Onedrive to me?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-22T05:06:21+00:00

    Assuming I figure out which version of Excel didn't have this issue, that would be a nice workaround. But I've since utilized new features that came in recent updates so that would be a new issue. That wouldn't really solve the issue long-term for me either.

    Is there anything else I can do? Try to get this communicated to the Excel team so it can get patched? Find some other workaround with the current version of Excel?

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-03-22T05:02:10+00:00

    A. Try to update your Office again so that if any patch is released by Microsoft that would flow in. Sometimes you have to try many times before an update is recognized by your Office.

    B. Another option is roll back to previous stable version which you had. To rollback -

    1. Uninstall the latest version of Office - https://support.office.com/en-us/article/Uninst...
    2. Install the previous stable version - https://support.office.com/en-us/article/Update...

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-03-22T04:46:59+00:00

    macOS 10.13.3

    Excel 16.11.1

    The problem started a few months ago. I'm fairly certain it started right after an Excel update.

    Was this answer helpful?

    0 comments
  5. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-03-22T04:45:13+00:00
    1. What is your Mac OS version?
    2. What is your Office version?
    3. Has the problem started recently particularly after an update or was it always there?

    Was this answer helpful?

    0 comments