'%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 IMAGE Function #UNKNOWN Error After Reopening Workbook
Question details
The user needs to resolve an issue where cells using the IMAGE function display an #UNKNOWN! error upon reopening a saved workbook.
- Product
- Microsoft Excel (Office LTSC Professional Plus 2024 Preview)
- Device & OS
- not provided
- Scenario
- Opening a previously saved Excel workbook that contains cells utilizing the new IMAGE function.
- Observed behavior
- The cells containing the IMAGE formula show the #UNKNOWN! error instead of the image until the user manually reactivates each cell.
Ensure your workbook is safely backed up before attempting mass formula recalculations, and check if there are any available software updates for your Office preview version.
Manually Reactivate Cells and Report the Bug to Microsoft
Since this is a known bug in the Office LTSC 2024 Preview, you will need to refresh the cells to display the images and submit a bug report for a permanent fix in future updates.
Preview builds are meant for testing and frequently contain bugs with newer features like the IMAGE function. Reporting the issue directly helps developers push a patch before the final release.
Click on the cell displaying the #UNKNOWN! error, place your cursor in the formula bar at the top, and press Enter to reload the IMAGE function.
Go to the 'Help' tab located on the Excel ribbon menu and click on 'Feedback' to open the feedback panel on the right side of the screen.
Select 'Report a Problem', accurately describe the issue with the IMAGE function turning into #UNKNOWN! upon reopening the workbook, and submit your report to Microsoft.
Switch to WPS Office for a Stable Spreadsheet Experience
If you are tired of dealing with preview build bugs and unstable features in Microsoft Excel, WPS Office provides a highly compatible, free, and lightweight alternative for all your spreadsheet needs.
- 1. Download the installer: Visit the official WPS Office website and click the free download button to get the latest stable version.
- 2. Install WPS Office: Run the downloaded installation file and follow the quick on-screen instructions to set up the software.
- 3. Open your spreadsheet: Launch WPS Spreadsheets and open your existing Excel workbook to continue working seamlessly without preview bugs.
Frequently Asked Questions
What does the #UNKNOWN! error mean in Excel?
The #UNKNOWN! error indicates that Excel does not recognize a function or data type used in a formula. This typically happens when opening a document in an older version of Excel that does not support the function, or due to a bug in a preview software build failing to recognize newly added functions like IMAGE.
Will the IMAGE function bug be fixed automatically?
Yes, bugs identified in Preview editions like Office LTSC 2024 are usually patched by Microsoft in subsequent updates. You must keep your Office application updated through the Account settings to receive the fix once it is released.
Is there a faster way to reactivate all cells showing #UNKNOWN!?
Yes. You can press F9 to force a recalculation of the entire workbook. If that does not work, use the Find and Replace tool (Ctrl + H), enter '=' in both the 'Find what' and 'Replace with' fields, and click 'Replace All' to force Excel to re-evaluate all formulas simultaneously.
