Fix Excel Online Workbooks That Cannot Load Because of Too Many Objects
Question details
The user needs to open an Excel workbook online when a section containing many objects does not load.

- Product
- Microsoft Excel Online
- Device & OS
- not provided
- Scenario
- A workbook containing charts, shapes, pictures, or other objects was split into separate year-based sections for online editing.
- Observed behavior
- The 2018 section opens and can be edited, but the 2019-to-current section does not open in Excel Online.
Identify which workbook section fails to open and check whether you can open it in the desktop Excel application. Look for object-heavy sheets or features that may not be supported in Excel Online.
Reduce Objects in the Workbook Using Desktop Excel
Use desktop Excel to simplify the section that fails to load, then test it again online.
Download the workbook from its online storage and open it in the desktop Excel application.
On a suspected sheet, select Home > Find & Select > Selection Pane to review its shapes, pictures, and other listed objects.
Select unneeded objects in the Selection Pane or on the sheet and delete them. Review charts and other features that may not be supported online.
Use File > Save As to save the simplified workbook as a separate file, upload it to your online storage, and open it in Excel Online.

Split the Failing Section into Smaller Workbooks
Use this approach when the 2019-to-current section remains too complex after the initial split.
Work with Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility makes it easier to move existing files into WPS, although it does not fix Excel Online loading limitations.

Frequently Asked Questions
Why does one part of the workbook open while another does not?
The failing section may contain more objects or unsupported features than the section that opens. Open it in desktop Excel and inspect its sheets, charts, shapes, and pictures.
How can I find shapes and pictures in desktop Excel?
On the sheet you want to inspect, select Home > Find & Select > Selection Pane. Review the listed objects and delete items you no longer need.
Will splitting the workbook always fix the loading problem?
No. A split file can still contain too many objects or unsupported features. Test each smaller file in Excel Online and simplify any section that still fails.
What should I do if the workbook needs features Excel Online does not support?
Open the workbook in the desktop Excel application to work with those features, or remove them from a separate copy before trying Excel Online again.




