Excel Online not working or not opening files is a common problem among Windows 10 users, but it has general workarounds that can resolve it.
However, for more specific issues, one would have to state the exact error they receive when working with the program.
Sometimes the issue appears if someone edits a workbook in Excel Online, and then leaves the document open, without making any additional changes for up to 6 hours.
Here are a few elements that may cause Excel Online not to open files or open too slowly:
- Worksheet protection. If you remove this, it may not be the best option as it helps prevent others from editing certain cells that may or may not contain formulas
- Defined names. You may not remove these, because they’re used for data validation and Excel Web Access web part uses it
- Vlookup formulas. These can break the calculation chain, so leave it as is
- Styles: Many times, Excel Online users have many cell styles, which together with other elements in the workbook can cause the load time to be slower, thus Excel Online may not work or open files.
This article looks at solutions that you can try if your Excel Online is not working or not opening your files.
How can I fix Excel Online not working/not opening files?
- Use a different browser
- Reset browser and clear cache
- Try Two-Step verification
- Set Default File opening behavior
- Download file and resave to drive
- Check the size of your file
- Try a different office suite
1. Use a different browser
If you keep on having issues with your browser when opening Excel Online then it may be a good option to use a different browser. In that matter, we recommend you switch to Opera.
It’s a great error-free browser that comes with amazing features that not only allow you to customize it based on your needs but it will also help you save a lot of time.
It’s fast, reliable and puts great emphasis on your online security. The free VPN and built-in adblocker will keep you safe and protected. Your browsing will be much faster due to the adblocker that will keep unwanted ads away from you.
The Workspace feature, Integrated messenger for social media, Search tab, and bookmarks management are great tools that come in handy especially when you have a lot of tabs opened.
If you want a reliable browser, a fast connection with a flexible and easy-to-customize interface then this is your best choice!
2. Reset the browser and clear cache
- Start Internet Explorer.
- Go to Tools menu.
- Click Internet options.
- Next, click the Advanced tab.
- Click Reset or Restore Default.
- Under Reset Internet Explorer Settings dialog box, click Reset.
- Select Delete personal settings.
- Click Close and exit.
- Restart Internet Explorer
3. Try Two-Step Verification
Two-step verification protects you by making it hard for anyone else to log in to your Microsoft account, by using two identification methods including your password, and contact or security information.
Whether someone else gets your password, they won’t be able to access your account without your security information, which is why it is important to have different passwords on all your accounts.
To set up this two-step verification, you will get a security code sent to your email, or an SMS via phone, or an authenticator app each time you log in on a device that is not trusted.
When this is off, you only need to verify your identity using the codes at different times, which is risky to your account.
4. Set Default File opening behavior
- Go to the document library page that the Excel files are stored.
- Click the Library tab.
- Under the Settings group, select Library settings.
- Go to the Document Library settings page.
- Choose Advanced settings.
- Under Advanced settings, find the Opening document in the browser.
- Select Open in the browser.
- Click OK.
Note: If you cannot find the Library tab or it is grayed out, ask your admin to check the library permission for you. To do this:
- Login with an admin account.
- Go to the library.
- Click library.
- Click library permission.
- Verify the permission showing for the user who is experiencing the problem with Excel Online
5. Download file and re-save to drive
If Excel Online is not working or not opening files, download the file and try to open it using the Excel desktop application.
If this helps, save the file again, and upload it to OneDrive and see if it helps fix the problem.
You can also ensure that you close all documents as you finish using them to avoid such issues happening again and ask anyone you share the documents with to do the same.
6. Check the size of your file
If you’re working with a large file, it is a potential complication on Excel Online as it may not be supported, or it will take too long to open, which may cause Excel Online not to work or to open files.
Usually, five to ten seconds in, your file will fully open and/or calculate in Excel when you download it, and this may be too complex for Excel Online to handle.
You’d have to make the file smaller or less complex, then it will open in Excel Online. Depending on your calculation needs, you can get the file to open by changing the calculation method to manual.
7. Try a different office suite
If you are still unsatisfied with MS office or the above-mentioned solutions didn’t solve your problem, we’d recommend you give WPS Office a try. It is a great free alternative for using Excel Online.
WPS Office allows you to synchronize your documents at any moment and any change you will make on your devices will be applied automatically.
Moreover, WPS Office is suitable for Windows, Mac, Android, Linux, and IOs. You can perform any type of editing and open all types of Word, Excel, and PDF documents, all in just one place.
It has alternatives for each tool incorporated in Microsoft Office, so you can use to create and manage text documents, presentations, and spreadsheets.
Did any of these solutions help? Let us know in the comments section below.