Insert Image In Cell - which versions of excel does this work with?

[perky890]

I currently have Excel 2024 LTSC for Mac. Im trying to use the insert image into cell function however it doesn't work. After saving the file and re-opening, the picture has been replaced with #UNKNOWN!

After a google search it seems to be a very common problem, even with the windows version of excel. I have tried the various suggested solutions, such as booting in safe mode, ensuring certain settings are in place etc but nothing works.

I pretty much need this feature exactly how it is supposed to work. I have tested it at work, and it works fine on Office 365.

Question: Can anybody please tell me if this feature works on any other standalone version of excel? I don't really want to pay for a subscription and sign up to 365, however I'm willing to purchase a different version if it will work.

Thanks

 

[jolivanes]

What is the code you import the picture with?
I don't have a Mac so I can't tell you anything about it but this counts for windows systems.

Pictures.Insert references a file.
Shapes.AddPicture permanently inbeds picture.

Try it this way, after changing references.

ActiveSheet.Shapes.AddPicture("C:\Folder Name\Picture Name.JPG", 0, -1, Cells(2, 3).Left, Cells(2, 3).Top, -1, -1).Name = "Picture 1"

 

[perky890]

Thanks, im at work at the moment. Ive tried the code in excel365 for windows and it inserts the image into the sheet, but I need it in the cell.

On my mac version is works fine to insert an image into the sheet, its inserting it into the cell where it doesnt work.

From the ribbon bar, when I go "Insert > Pictures > Place in Cell > This Device..." the image is inserted physically in the cell, nice and small. This is what I need.

 

[RoryA]

It should be available in Mac 365 Version 16.79.2 (Build 23112723) or later. It's not listed as available in any SA version of Office as far as I can see, Windows or Mac.

 

[jolivanes]

To set the size, read this.

Shapes.AddPicture method (Excel)

Office VBA reference topic

learn.microsoft.com

 

[MARK858]

It should be available in Mac 365 Version 16.79.2 (Build 23112723) or later. It's not listed as available in any SA version of Office as far as I can see, Windows or Mac.

Listed in the link below for 2024

What's new in Excel 2024 for Windows and Mac - Microsoft Support

support.microsoft.com

 

[RoryA]

Listed in the link below for 2024

What's new in Excel 2024 for Windows and Mac - Microsoft Support

support.microsoft.com

I don’t see it there? The Image function is there.

 

[MARK858]

I don’t see it there? The Image function is there.

From the link in the Image function section, click the Applies to drop down, or am I looking at the wrong thing?

Insert Picture in-cell in Excel - Microsoft Support

Learn how to insert local images in Excel.

support.microsoft.com

 

[RoryA]

I haven’t checked recently but I suspect the IMAGE function might be the only part of that that applies to non-365. I’m pretty sure you can’t use the place picture in cell in 2019 at least.