'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Insert Picture in Cell Missing and #UNKNOWN! Error
Question details
The user needs to restore the 'Insert Picture in Cell' command and fix existing in-cell images that are currently displaying as an error.
- Product
- Microsoft Excel (Office 2021, Microsoft 365)
- Device & OS
- Windows
- Scenario
- Opening an existing Excel workbook containing pictures in cells, or attempting to insert new pictures into cells after a recent Windows update.
- Observed behavior
- The 'Insert Picture in Cell' option has disappeared from the Excel ribbon, and any existing in-cell images are replaced with the #UNKNOWN! error value.
Verify your exact Microsoft Office edition and build number by navigating to File > Account, as feature availability strictly depends on your specific update channel.
Check Office Version and Install Latest Updates
Ensure your Excel version formally supports the picture-in-cell feature and that no patches are missing.
Microsoft's picture-in-cell feature is officially supported in Microsoft 365 and Office LTSC 2024. If you are using Office 2021, the feature may have been temporarily available and later altered or removed during a routine update.
Open Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom left menu to view your exact Office edition.
Under 'Product Information', click the 'Update Options' button next to Office Updates and select 'Update Now'.
Once the updates are complete, restart Excel, open your workbook, and check if the 'Insert Picture in Cell' command is restored in the Insert tab.
Report Issue and Rollback Office Update
If the feature disappeared immediately after a recent update despite being supported, rolling back your Office version can serve as a temporary workaround.
Use WPS Office for Stable and Reliable Spreadsheet Management
If Microsoft Excel updates frequently disrupt your workflow or remove features unexpectedly, consider switching to WPS Office. It provides a highly stable environment for all your spreadsheet needs, ensuring your formatting remains intact without relying on unpredictable update channels.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your Windows device.
- 2. Install and Launch: Run the installer, complete the setup, and open the WPS Spreadsheets application.
- 3. Open Your Workbook: Open your existing .xlsx files directly in WPS Office to view and edit your data safely.
Frequently Asked Questions
Why does Excel show #UNKNOWN! for my images?
The #UNKNOWN! error appears when an Excel workbook contains a specific data type or feature—like the new Picture-in-Cell data type—that is not supported or has been disabled in the current version of Excel you are using.
Which versions of Excel support the Insert Picture in Cell feature?
Officially, the feature is supported in Microsoft 365 subscriptions and Office LTSC 2024. While it may have briefly appeared in some Office 2021 builds, Microsoft update channels occasionally restrict or remove experimental features from standalone non-subscription versions.
Can I extract the pictures if they currently show as #UNKNOWN!?
If the file is opened in an unsupported version, the images cannot be rendered or extracted easily. To recover them, you must open the workbook in a supported version like Microsoft 365, or restore your Office installation to the previous build where the feature was actively working.
