Software⏱️ 4 min read📅 2026-06-15

How to Fix: Excel error charts and drawings

Excel error charts and drawings issue

Quick Answer: Check for corrupted files or damaged Excel add-ins, and try repairing the file or reinstalling Excel.

📋 Table of Contents

  1. 💡 Why You Are Getting This Error
  2. 🚀 How to Resolve This Issue
  3. ✨ Wrapping Up

The user is experiencing an error in Excel where they receive an error message about drawings and cannot view charts or drawings, even if they are present. This issue affects users who open Excel files (.xlsm or .xlsx) on their system and does not occur when opening the file from another PC/user. The user has tried repairing the file, but the report generated by Excel does not provide any assistance.

This issue can be frustrating for users as it prevents them from viewing important charts and drawings in their Excel files. To resolve this issue, we will go through the possible causes and provide a step-by-step guide to fix the problem.

💡 Why You Are Getting This Error

  • The primary cause of this error is likely related to the corrupted or damaged Excel file. When a file is corrupted, it can cause errors in various features, including charts and drawings. This issue may be caused by user actions such as deleting or modifying data, or by external factors like malware or system crashes.
  • Another possible reason for this error could be related to the version of Excel being used. If the user is using an outdated or incompatible version of Excel, it can cause issues with charts and drawings.

🚀 How to Resolve This Issue

Repairing the Excel file

  1. Step 1: Step 1: Open Excel and go to the 'File' menu.
  2. Step 2: Step 2: Select 'Open' and choose the corrupted Excel file (.xlsm or .xlsx).
  3. Step 3: Step 3: Click on 'Options' in the 'Save As' dialog box and select 'Repair' from the dropdown menu. This will attempt to repair the file without overwriting any data.
  4. Step 4: Step 4: If the repair is successful, try opening the file again to see if the issue persists.
  5. Step 5: If the issue still occurs after repairing the file, proceed to the next method.

Checking for corrupted or damaged Excel files

  1. Step 1: Step 1: Open Excel and go to the 'File' menu.
  2. Step 2: Step 2: Select 'Options' and then click on 'Add-ins'. Make sure that any add-ins related to charts or drawings are disabled.
  3. Step 3: Step 3: Click on 'Trust Center' in the 'Trust Center Settings' dialog box and select 'Trusted Sources' from the dropdown menu. Ensure that any untrusted sources, including external files or macros, are disabled.
  4. Step 4: Step 4: If you have recently installed Power BI, try uninstalling it to see if it's causing the issue.
  5. Step 5: If none of these steps resolve the issue, proceed to the next step.

✨ Wrapping Up

To summarize, the primary cause of this error is likely related to a corrupted or damaged Excel file. By following the steps outlined in method 1 (repairing the Excel file), you should be able to fix the issue. If that doesn't work, try checking for corrupted or damaged Excel files by disabling add-ins and untrusted sources. If none of these steps resolve the issue, it may be worth considering reinstalling Excel.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Pc crashes shortly after launching game (rainbow

Fix Pc crashes shortly after launching game (rainbow six siege). Compl

How to Fix: Installing an APK on a locked down phone

Installing an APK on a locked down phone: Try using a rooted device, e

How to Fix: New PC build- no signal and no clue

Fix New PC build- no signal and no clue. Complete troubleshooting guid