Fix the Excel Online File Too Large Error for a Shared Workbook
Question details
The user needs to open a shared workbook in Excel Online when its file size prevents it from opening.

- 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.
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.
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.
Open the shared workbook in desktop Excel, then use File > Save As or Save a Copy to create a separate working copy.
Review the sheet tabs and delete worksheets or excess data that are no longer needed. Check with collaborators before removing shared content.
Select unnecessary formatted cells, then choose Home > Clear > Clear Formats. Avoid clearing formatting needed for dates, readability, or reports.
Select a picture and choose Picture Format > Compress Pictures, or select an unneeded picture and press Delete.
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.

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.

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.




