'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for the Web 'Something Went Wrong' Error on OneDrive
Question details
The user needs to resolve a 'Something Went Wrong' error encountered when trying to open a large Excel file in the web version of Excel.
- Product
- Excel for the Web / OneDrive
- Device & OS
- not provided
- Scenario
- Attempting to open, view, or edit a large Excel workbook stored on OneDrive using a web browser.
- Observed behavior
- Excel for the web displays a 'Something Went Wrong' error and fails to load the file, even though the exact same workbook opens perfectly in the desktop version of Excel.
Check your internet connection and ensure your web browser is fully updated. Clearing your browser cache and cookies can often resolve temporary script loading issues before attempting file-specific fixes.
Copy Workbook Contents to a New File
Transferring your data to a new, blank workbook can clear underlying file corruption or unsupported formatting issues preventing the web version from loading.
Large workbooks often accumulate background formatting, hidden objects, or minor file corruptions over time. By moving the raw data into a fresh file container, you bypass these hidden triggers that crash the web viewer.
Launch the desktop version of Microsoft Excel and open the problematic large workbook.
Navigate to your main worksheet, press Ctrl+A to select all data, and then press Ctrl+C to copy it.
Click on File > New and select 'Blank workbook' to create a fresh file.
Press Ctrl+V to paste the copied data into the new workbook. Save the file with a new name to your local drive.
Upload the newly created workbook back to your OneDrive account and open it in Excel for the web to test if the error is resolved.
Isolate the Issue with a Blank Test File
Determine whether the issue is specific to the large workbook's contents or if there is a broader service problem with Excel for the web or OneDrive.
Experience Seamless Spreadsheet Editing with WPS Office
Tired of web sync errors and large file crashes? WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office. With built-in WPS Cloud, you can effortlessly sync, open, and edit massive spreadsheets across all your devices without unexpected 'Something went wrong' interruptions.
- 1. Download and Install: Get the free WPS Office installer from the official website and complete the quick installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your large .xlsx files directly. The software is optimized to load heavy data quickly.
- 3. Save to WPS Cloud: Enable WPS Cloud sync to securely back up your files and seamlessly access them from your web browser or mobile device without size limit errors.
Frequently Asked Questions
Why does my Excel file open on the desktop app but not in the web browser?
Excel for the web has strict file size and complexity limits that the desktop app does not. If your workbook contains heavy VBA macros, complex arrays, unsupported data models, or exceeds the web viewer's memory limit, it will trigger an error online while still opening smoothly on your desktop.
What is the maximum file size limit for opening Excel files in OneDrive?
For Microsoft 365, the file size limit for viewing and editing Excel workbooks directly in the web browser is typically 100 MB. Files larger than this must be opened using the desktop application.
How do I know if OneDrive or Excel for the web is experiencing a service outage?
You can verify this by trying to open a newly created blank Excel file or a different file type like a Word document on OneDrive. If none of them open, you can visit the Microsoft Service Health status page to check for ongoing server outages.
Will clearing my browser cache fix the 'Something went wrong' error?
Sometimes. Corrupted browser cache or outdated cookies can interfere with Office for the web's backend scripts. Navigating to your browser settings and clearing cache and site data for OneDrive and Office.com often resolves basic loading problems.
