'%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)
How to Fix Excel Recovery Removed a Drawing Error
Question details
The user experienced workbook corruption where the Excel recovery process permanently removed drawings or other objects from the file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or recovering a recently saved Excel workbook containing drawings, especially after switching between Excel desktop and Excel for the web.
- Observed behavior
- Excel displays a recovery error and successfully opens the file, but drawings, shapes, or other embedded objects are completely removed.
Close the corrupted file without saving any new changes to prevent overwriting earlier functional versions of your workbook stored on your system or cloud.
Restore an Earlier Version from Version History
Use this method to roll back your workbook to a previous state before the corruption occurred, provided the file was saved on OneDrive or SharePoint.
When Excel files are synced to OneDrive or SharePoint, Microsoft 365 automatically maintains a history of your changes. This is the most reliable way to recover objects that were stripped out during a corrupted save.
Open the corrupted file in Excel. Click on 'File' in the top left corner, select 'Info', and then click on 'Version History'.
A panel will appear on the right side of your screen showing previous saves organized by date and time. Click on the version saved just before you experienced the recovery error to open it in a new window.
Verify that your drawings and objects are present in this historical version. Click the 'Restore' button at the top of the window to overwrite the corrupted file, or select 'Save a Copy' to keep both versions.
Recover from a Local Backup or AutoRecover File
If you do not use cloud storage, you can attempt to retrieve a functional copy from Excel's local backup or AutoRecover folder.
Troubleshoot Desktop and Web Compatibility
Identify if compatibility differences between Excel for the web and Excel desktop are causing the objects to be discarded during the save process.
Try WPS Office for Stable Spreadsheet Management
If Microsoft Excel frequently corrupts your files or drops graphical objects due to compatibility issues between web and desktop versions, consider switching to WPS Spreadsheet. It is a highly compatible, free alternative that handles complex documents with unparalleled stability.
- 1. Download WPS Office: Visit the official WPS Office website to download and install the free suite.
- 2. Open your corrupted workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly. The robust engine often opens files that trigger errors in other software.
Frequently Asked Questions
Why did Excel delete my drawings during the recovery process?
When an Excel workbook becomes corrupted during a save operation, the automatic recovery feature strips out unreadable or damaged XML elements—such as drawings or embedded objects—to salvage the rest of the spreadsheet's text and data. This often happens due to compatibility conflicts between Excel desktop and Excel for the web.
Can I recover my removed drawings without a backup?
Unfortunately, if Excel completely stripped the drawings during recovery and you do not have version history, cloud backups, or an AutoRecover file available, the objects are permanently lost and must be recreated manually.
How can I prevent file corruption when saving Excel files with drawings?
Ensure a stable internet connection when saving files directly to cloud services like OneDrive. Avoid editing the same document simultaneously across different platforms (e.g., desktop and web). Additionally, manually save backup copies before making extensive graphical changes.
