File Sharing Problems

Fix the Excel Online File Too Large Error for a Shared Workbook

Olivia MillerOlivia Miller Nov 22, 2026 868 views

Question details

The user needs to open a shared workbook in Excel Online when its file size prevents it from opening.

Fix the Excel Online File Too Large Error for a Shared Workbook
Product
Microsoft Excel Online
Device & OS
not provided
Scenario
A user opens a shared workbook in a browser while other users access the same file in desktop Excel.
Observed behavior
Excel Online reports that the workbook is too large, although it can open in the desktop application.
Before you start

Check the workbook's file size and confirm that you or a collaborator can open it in desktop Excel. The reported limit is 30 MB in this case, but workbook limits can vary by service and configuration.

Solution 1Recommended

Reduce the workbook size in desktop Excel and share it again

Use desktop Excel to remove unnecessary content and create a smaller copy that may open in the browser.

1
Open and save a copy

Open the shared workbook in desktop Excel, then use File > Save As or Save a Copy to create a separate working copy.

2
Remove unused sheets and data

Review the sheet tabs and delete worksheets or excess data that are no longer needed. Check with collaborators before removing shared content.

3
Clear excess formatting

Select unnecessary formatted cells, then choose Home > Clear > Clear Formats. Avoid clearing formatting needed for dates, readability, or reports.

4
Compress or remove images

Select a picture and choose Picture Format > Compress Pictures, or select an unneeded picture and press Delete.

5
Save and test the smaller file

Save the copy, check its file size, and upload it to the shared location. Open the uploaded file in Excel Online and use Share to give collaborators access.

Reduce the workbook size in desktop Excel and share it again
Limits can vary: A smaller file may still exceed the applicable browser limit. If it does, remove more unnecessary content or continue using desktop Excel.
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheet to continue editing without relying on Excel Online; it does not change Microsoft's browser file-size limits.

Edit spreadsheets in a desktop application instead of Excel OnlineOpen and save compatible Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can my colleague open the workbook in desktop Excel but not in Excel Online?

Excel Online can have different workbook size limits from desktop Excel. Open the file in desktop Excel to reduce its size, then upload the smaller copy and test it in the browser.

Is 30 MB the limit for every Excel Online workbook?

No. The applicable limit can vary by service and configuration. Check the limit for the location where the workbook is stored and compare it with the file's size.

How do I reduce the size of pictures in an Excel workbook?

In desktop Excel, select a picture and choose Picture Format > Compress Pictures. You can also select and delete pictures that the workbook no longer needs.

Will clearing formatting remove my cell values?

Home > Clear > Clear Formats removes formatting rather than cell contents. It can also remove useful number and date formats, so select only cells with unnecessary formatting.