How to Fix Images and Objects Not Visible in Excel
Question details
The user needs to restore the visibility of images and objects in an Excel workbook that are currently failing to display.
- Product
- Excel for Microsoft 365
- Device & OS
- Windows
- Scenario
- Viewing a worksheet that contains screen captures or objects after migrating to Excel for Microsoft 365.
- Observed behavior
- Images and objects are entirely invisible or missing, even though they display correctly in older versions like Excel 2007. Altering hardware graphics settings temporarily resulted in a blank white application window.
Before changing advanced application settings, verify that your Windows operating system and Microsoft Office installation are updated to the latest versions, as missing patches frequently cause graphics rendering issues.
Enable the 'Show All Objects' Display Setting
Sometimes object display settings are inadvertently altered. Verifying this setting is the most direct way to ensure Excel is allowed to render images.
Excel has built-in workbook display options that allow users to hide all objects, which can improve performance on large files but causes images to vanish. Checking this configuration should be your first troubleshooting step.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the menu.
In the Excel Options dialog box, click on 'Advanced' in the left-hand pane.
Scroll down to the section labeled 'Display options for this workbook'. Under the 'For objects, show:' heading, select the 'All' radio button, then click 'OK' to apply the changes.
Test Excel in Safe Mode and Check Graphics Acceleration
Running Excel in Safe Mode bypasses add-ins and certain display drivers that may be conflicting with image rendering.
View and Edit Your Workbooks Seamlessly with WPS Office
If Microsoft Excel continues to struggle with rendering images or causes graphics driver conflicts on your device, consider using WPS Office. It is a highly compatible, free, and lightweight alternative that easily opens Excel workbooks and reliably displays your screen captures and objects.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Office and select the Spreadsheet module from the main dashboard.
- 3. View Your File: Open your existing Excel workbook. WPS Spreadsheet will automatically render all hidden images and objects accurately.
Frequently Asked Questions
Why do images show up in older Excel versions but not in Excel for Microsoft 365?
Newer versions of Excel utilize different graphics rendering engines and updated hardware acceleration methods. If your laptop's display drivers are outdated or incompatible with Microsoft 365's engine, images might fail to render, even though they display perfectly in older versions like Excel 2007.
What should I do if disabling hardware graphics acceleration turns Excel entirely blank?
If the screen turns entirely white after changing this setting, it indicates a severe driver conflict. You must revert the setting by navigating back to File > Options > Advanced (using keyboard shortcuts like Alt, F, T if you cannot see the menus) and unchecking the option, or by performing a full Microsoft Office repair from the Windows Control Panel.
Can a corrupted workbook cause images to disappear?
Yes, corruption within the structure of an individual workbook file can lead to missing objects. You can try opening the file using the 'Open and Repair' feature found in Excel's Open dialog box to attempt to fix internal file errors and recover the images.
