Forum Discussion

AButler1910's avatar
AButler1910
Copper Contributor
Mar 20, 2024

#unknown! displayed in excel where an inserted picture should be located

A supplier is sending me an excel template which contains pictures in a cell The picture can be viewed in web based outlook and web based excel but when I download the file the cell states #unknown!...
excel
WeberELLC's avatar
WeberELLC
Copper Contributor
Aug 16, 2024

I'm having the same issue.  I created the original spreadsheet on an Excel 365 desktop version and placed the images by copying an image and then simply pasting it and clicking to place the picture in the cell.  When pasting the images, I was never asked if I wanted to Embed vs. Link so I presumed that the default behavior was to Embed as it has always been.  I cannot determine if there is any linkage, but it does not appear to be linked but rather embedded.  The document is stored in my OneDrive folder.

 

Now, trying to open the file in Excel as part of an MS Office LTSC Professional Plus 2021 install, this is the program saying the pictures are #UNKNOWN! with an Unavailable data type.

 

I cannot find anything that says that this behavior was being changed in any way between these versions. 

 

It's just flat-out broken.

Resources