Fix Excel 2101 Freezing or Unresponsive When Working with Charts
Question details
Microsoft Excel temporarily freezes and displays a Not Responding message when the user attempts to create or edit charts.

- Product
- Microsoft Excel (Version 2101)
- Device & OS
- Windows
- Scenario
- Creating, editing, or rendering charts within an existing Excel workbook.
- Observed behavior
- Excel becomes unresponsive while processing charts. Standard troubleshooting steps like Office Repair, Safe Mode, and creating a new Windows profile do not resolve the problem.
Ensure you have saved your recent work and backed up the problematic workbook before modifying system graphics settings or updating drivers.
Disable Hardware Graphics Acceleration and Update Drivers
Graphics rendering conflicts are a common cause of chart-related freezes in Excel.
Charts rely heavily on your computer's graphical processing capabilities. If the graphics driver is outdated or conflicting with Excel's rendering engine, turning off hardware acceleration can bypass the issue.
Open Excel, go to File > Options > Advanced. Scroll down to the Display section, check the box for 'Disable hardware graphics acceleration' (if available), and click OK. Restart Excel.
Right-click the Windows Start button and select Device Manager. Expand 'Display adapters', right-click your graphics card, and select 'Update driver'. Choose to search automatically for updated driver software.

Install the Latest Office and Windows Updates
Microsoft frequently releases patches to address specific performance bugs in versions like Excel 2101.
Test and Recreate the Chart in a New Workbook
The issue might be tied to hidden corruption within the specific workbook rather than the Excel application itself.
Avoid Excel Chart Freezes with WPS Office
If Microsoft Excel continues to hang, freeze, or crash when handling complex charts, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for creating, editing, and rendering complex spreadsheets and charts smoothly without performance lags.
- 1. Download WPS Office: Visit the official WPS website to download and install the free version of WPS Office.
- 2. Open your problematic workbook: Launch WPS Spreadsheet, click 'Open', and select your existing .xlsx file containing the charts.
- 3. Edit charts smoothly: Continue modifying your data and charts without experiencing the 'Not Responding' errors found in Excel 2101.

Frequently Asked Questions
Why does Excel freeze only when I click on a chart?
Charts require more graphical processing power than standard text cells. If your graphics drivers are outdated, or if hardware acceleration is conflicting with your system, Excel may struggle to render the visual elements and temporarily freeze.
Does running a Quick Repair fix chart freezing issues?
While Quick Repair or Online Repair can fix corrupted Office application files, they often do not resolve issues caused by outdated graphics drivers, pending Windows updates, or specific version bugs present in Excel 2101.
How do I check if a third-party add-in is causing Excel to hang on charts?
Hold the Ctrl key while launching Excel to open it in Safe Mode. If you can edit charts smoothly in Safe Mode, a third-party add-in is likely the culprit. You can manage and disable add-ins by going to File > Options > Add-ins.
What should I do if my workbook crashes even after recreating the charts?
If the issue persists in a new workbook with new charts, the problem may lie deep within your system's rendering capabilities. You should ensure your graphics drivers are fully updated from the manufacturer's website, or contact Microsoft Support with your crash logs for further investigation.




