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

AlbertS895 

Let's address each user's concerns individually.

AButler1910 :

• Issue: The user tested the process with the supplier and discovered that placing the picture in a cell causes it to show as "#UNKNOWN!" when shared. However, if the picture is not placed within the cell, it displays correctly.
• Solution:
• Compatibility Issue: This appears to be a compatibility issue between different versions or configurations of Excel, particularly when it comes to how images are handled within cells.
• Temporary Workaround: Since placing the image outside of the cell works, you might suggest continuing to do so until Microsoft addresses this issue.
• Long-Term Solution: Both parties should consider updating to the latest version of Excel and checking if there are any recent updates or patches that resolve this issue. Also, submitting feedback to Microsoft support might help them recognize and address this compatibility issue in future updates.

bashobitewari :

• Issue: The user has already tried ensuring that the "Show all" option is selected under the "For objects, show" setting in Excel Options, but the pictures still do not display.
• Solution:
• Possible Cause: This might still be related to how Excel handles image embedding vs. linking, particularly if the images are somehow corrupted or not fully embedded.
• Actions to Try:
1. Reinsert the Images: Reinsert the images directly and make sure they are fully embedded by saving the file immediately after inserting.
2. Test in Another Environment: Try opening the file on another system or in Excel Web to see if the issue persists.
3. File Repair: Use Excel's built-in repair tool by going to File > Open, selecting the problematic file, and choosing "Open and Repair" from the dropdown next to the "Open" button.
4. Update Excel: Ensure that Excel is fully updated, as Microsoft often releases patches that fix bugs like this.

WeberELLC :

• Issue: The user created a spreadsheet in Excel 365, assumed that the images were embedded (since there was no option to choose), but finds that when opening the file in Excel LTSC Professional Plus 2021, the images display as "#UNKNOWN!".
• Solution:
• Understanding the Problem: This seems like an issue between Excel 365 and Excel LTSC Professional Plus 2021, where the latter might not fully support or recognize the method used to embed images in Excel 365.
• Possible Solutions:
1. Check for Compatibility: Ensure that both versions of Excel are updated. Microsoft may have released patches that improve compatibility between different versions.
2. Alternative Insertion Method: Instead of using the copy-paste method, try inserting the image using Insert > Pictures, and select "From this device." This might force Excel to embed the image differently.
3. File Save As: Try saving the file in a different format, such as .xlsb (Excel Binary Workbook) or .xlsx, and see if that resolves the issue.
4. Contact Microsoft Support: Since this issue might be related to differences between Excel versions, reaching out to Microsoft support for specific guidance could be helpful.

General for All Users: Given that this issue seems related to how different Excel versions handle image embedding, keeping both Excel and Windows fully updated is crucial. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.