File Cannot Open

Fix Excel Online Workbooks That Cannot Load Because of Too Many Objects

John WilsonJohn Wilson Nov 14, 2026 869 views

Question details

The user needs to open an Excel workbook online when a section containing many objects does not load.

Fix an Excel Online Workbook That Cannot Load Because of Too Many Objects
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.
Before you start

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.

Solution 1Recommended

Reduce Objects in the Workbook Using Desktop Excel

Use desktop Excel to simplify the section that fails to load, then test it again online.

1
Open the failing file

Download the workbook from its online storage and open it in the desktop Excel application.

2
Find objects on each sheet

On a suspected sheet, select Home > Find & Select > Selection Pane to review its shapes, pictures, and other listed objects.

3
Remove unnecessary items

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.

4
Save and test 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.

Reduce Objects in the Workbook Using Desktop Excel
Check the failing section: If the workbook still does not load, another sheet or unsupported feature may need attention. Desktop Excel can be used for features that Excel Online cannot support.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats, including XLSXReview workbook sheets and objects outside Excel OnlineFree and lightweight for everyday office tasks
microsoft office alternative - wps office

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.