Share via

How do I use the IMAGE function with local images?

Anonymous
2023-04-26T15:09:49+00:00

I want to use a cell value as the image name so it puts each image in a new cell that matches that cells file name.

I tried linking online image files so I know it works but whenever I try local images it just errors. I saw that local images may not be available yet, has there been an update or a work around yet?

Thanks

Microsoft 365 and Office | Excel | For business | MacOS

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
Answer accepted by question author
  1. Lz._ 38,106 Reputation points Volunteer Moderator
    2023-04-26T16:20:15+00:00

    Hi Connor

    Unfortunately this isn't possible and it's clearly documented:

    44 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-07-09T17:37:21+00:00

    Some users of Excel will have these new options available. This should be available to most beta channel users, and this will be followed by availability for certain subscribers:

    7 people found this answer helpful.
    0 comments

40 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-06-06T18:42:06+00:00

    Hi

    FYI - A new feature that will let you insert a picture from a file into a worksheet cell is just starting to roll out in the beta channel. Eventually this will be available for all Excel users if the testing works out.

    11 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-17T06:25:04+00:00

    If you had the image in a database you can do it. You can convert the image to base64 format and embed it. I have had success with both methods. The dataase method is in one of the books I authored.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-07-23T03:01:11+00:00

    Yes, it is possible to embed binary encoded images in an Excel cell. You can load blobs and images into a Data Model^1^or use the IMAGE function^2^ to insert images into cells from a source location along with alternative text. You can then move and resize cells, sort and filter, and work with images within an Excel table^2^.

    I hope that helps! Let me know if you have any other questions.

    What a I meant was this. The above is from Bing AI.

    2 people found this answer helpful.
    0 comments