Fix Excel for the Web Charts Freezing When Switching Worksheets
Question details
The user experiences frozen or stuck charts when navigating between different worksheets in Excel for the Web, often accompanied by an abnormally high chart count compared to the desktop version.

- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Navigating between different worksheets in an Excel workbook via a web browser.
- Observed behavior
- Charts remain visible or appear frozen on the screen when switching sheets. The workbook statistics show a massive discrepancy in chart counts (e.g., 1,881 in the web version vs. 78 in the desktop app), indicating potential workbook corruption or a severe web rendering issue.
Ensure you have a stable internet connection and try opening the workbook in the Excel desktop application to verify the actual number of charts before attempting any web-based fixes.
Optimize Workbook with Check Performance in Excel Web
Excel for the Web includes a built-in optimization tool designed to identify and remove excess formatting or hidden objects that degrade browser performance.
Workbooks can become bloated with invisible metadata, formatting, or corrupted objects over time. Running the Check Performance feature helps clean up the file and resolve web rendering freezes.
Launch Excel for the Web and open the problematic workbook.
Click on the **Review** tab located in the top ribbon menu.
Click the **Check Performance** button to initiate an automatic scan of your spreadsheet.
Review the optimization suggestions provided in the side pane and click **Optimize All** to remove unnecessary formatting and hidden objects.

Remove Duplicated Objects via Excel Desktop App
Opening the file in the desktop app allows you to manually inspect and delete corrupted or highly duplicated ghost charts that the web version struggles to render.
Create a Support Request via Microsoft 365 Admin Center
If optimization fails and the workbook is still corrupted, your organization's IT administrator may need to escalate the issue to Microsoft Support.
Experience Smooth Spreadsheet Performance with WPS Office
Avoid browser rendering lag and frozen charts by using a lightweight, high-performance desktop spreadsheet tool. WPS Office provides exceptional compatibility with Microsoft Excel formats and handles complex charts seamlessly without the bloat.
- 1. Download WPS Office: Visit the official WPS Office website and download the free desktop application.
- 2. Open your workbook: Launch WPS Spreadsheets, click **File** > **Open**, and select your existing .xlsx file.
- 3. Navigate without freezing: Switch between worksheets and manage your charts smoothly without browser limitations.

Frequently Asked Questions
Why does Excel for the web show thousands of charts while the desktop app shows very few?
This discrepancy is often caused by invisible, duplicated, or corrupted object metadata in the workbook. The web browser attempts to render all these ghost objects simultaneously, which overloads the browser's memory and causes the worksheet to freeze or display incorrect statistics.
Can I prevent charts from freezing in Excel for the Web?
Yes. You can prevent freezing by regularly clearing unnecessary formatting, avoiding copying and pasting large datasets with hidden web objects, and utilizing the Check Performance feature under the Review tab to keep your workbook optimized.
What should I do if Check Performance doesn't fix the frozen charts?
If the built-in optimization tool fails, you should open the file in the Excel desktop application to manually locate and delete hidden objects using the 'Go To Special' feature (Ctrl + G > Special > Objects). If the problem persists, contact your Microsoft 365 admin to submit a support ticket.




