Forum Discussion
#unknown! displayed in excel where an inserted picture should be located
Let's address each user's concerns individually.
- 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.
- 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:
- Reinsert the Images: Reinsert the images directly and make sure they are fully embedded by saving the file immediately after inserting.
- Test in Another Environment: Try opening the file on another system or in Excel Web to see if the issue persists.
- 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.
- Update Excel: Ensure that Excel is fully updated, as Microsoft often releases patches that fix bugs like this.
- 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:
- Check for Compatibility: Ensure that both versions of Excel are updated. Microsoft may have released patches that improve compatibility between different versions.
- 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.
- 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.
- 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.
- Bashobi_TewariSep 06, 2024Copper Contributor
NikolinoDE Sometimes when i open an excel sheet that I have worked on many times earlier, there are no images. Generally, if I re-start the laptop, and I reopen the file I can see the images, but every once in a way, there is no image and I get this in a box " The image part with relationship ID rld 1 was not found in the file" - where an inserted picture should be located. Please see below
This is MOST irritating as it happens quite frequently. This morning when I started my computer the file was fine. When I re-started my computer later, no images! Can ANYONE PLEASE help to fix this issue? Thanks in advance
- AlbertS895Aug 16, 2024Copper Contributor
NikolinoDE I have tested this across Excel Versions and everyone should be updated to the latest version due to company policy and still does not work. The main issue I had was that I was using the images in the cells so that I could use formulas on them and when they are taken out they are no longer linked to cells for the formulas to work. I have changed this to text as a work around but feels like this is defiantly a excel bug
- NikolinoDEAug 16, 2024Gold ContributorUnfortunately, I'm at my wits' end here too.
I can't think of an additional solution straight away.
The only thing I can recommend is to give Microsoft additional feedback.
Thank you for your patience.