How to Fix Excel Shapes Moving or Distorting in Older XLS Files
Question details
Users need to resolve an issue where shapes and objects shift or distort in older Excel files.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening, editing, or saving older XLS workbooks that contain embedded shapes, charts, or macros linked to objects.
- Observed behavior
- Shapes and charts become progressively distorted, shift from their original positions, or disappear entirely upon opening and updating the file.
Before making hardware or system changes, save a backup copy of your original XLS file in a safe location to prevent permanent data or shape loss during troubleshooting.
Disable Hardware Graphics Acceleration in Excel
Turning off hardware acceleration often resolves rendering issues with shapes and charts in older Excel files.
Hardware graphics acceleration offloads graphics rendering to your computer's GPU. In older Excel versions or older XLS files, conflicts between the GPU drivers and Excel can cause shapes and charts to render improperly or shift positions.
Open Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on 'Advanced' in the left pane.
Scroll down to the 'Display' section, check the box for 'Disable hardware graphics acceleration', and click 'OK' to apply the changes.
Update Display Drivers
Outdated graphics cards and drivers are a known cause of shape distortion in Office applications.
Open and Edit XLS Files Seamlessly with WPS Office
Since shape distortion in older XLS files is a persistent hardware-related issue in Microsoft Excel, consider using WPS Office. It provides robust compatibility with legacy XLS formats, ensuring your charts and shapes remain perfectly intact without relying on specific graphics hardware.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up WPS Office on your computer.
- 3. Open Your XLS File: Launch WPS Spreadsheets, click 'Open', and select your older XLS file. Your shapes and charts will render without moving or distorting.
Frequently Asked Questions
Why do Excel shapes distort more every time I open the file?
In older XLS files, Excel sometimes improperly calculates object positioning and scaling during the save and open process. This often happens when hardware graphics acceleration conflicts with your computer's display drivers, causing the spatial distortion to compound over time.
Can using Remote Desktop cause Excel shapes to move?
Yes. Remote Desktop sessions often use different virtual display drivers and resolutions than the local machine. This sudden mismatch can trigger the Excel rendering bug, causing charts and shapes to shift, scale improperly, or disappear.
How do I fix disappearing macros linked to shapes in Excel?
When shapes distort heavily or disappear, any macros assigned to those objects become inaccessible. To recover them, you must open an older backup version of the XLS file where the shapes are intact, disable hardware graphics acceleration in Excel's advanced settings, and save the document in a newer format like XLSM.
