Share this article

Improve this guide

We’re Sorry, Can’t Open The Workbook in The Browser (Excel): Fixed

Get back to editing your workbook on your browser with these fixes

4 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Thanks to web apps like Excel Online, accessing and editing your workbooks online shouldn’t be an issue. However, it is not all rosy, as users have been facing issues such as theExcel Online not working and can’t open fileserror.

The inability to open workbooks from Microsoft Excel or SharePoint is troubling users. As reported, they are usually met with theWe’re sorry we can’t open the workbook in the browsererror and can’t proceed.

This will provide some tips on how to solve this quickly and effectively.

Why won’t Excel open in the browser?

There are various reasons your workbook might not open in Excel on your browser. This can be because of an issue with the browser you are using.

Also, it might be because you have Sharepoint disabled. And to make a file accessible online on your browser, you need to have the feature enabled.

How can I fix the Sorry we can’t open your workbook in Excel online error?

1. Try with a different browser

Let’s start by migrating to Edge or IE. Yes, we know those might not be browsers of your choice, but they work the best with other web-based Microsoft applications.

Additionally, you can install specific IE-specific add-ons which might allow you unprecedented access to your workbook, be it SharePoint or Excel.

Alternatively, you can give Opera One a try. This Chromium-based browser checks all the boxes regarding reliability and safety.

So, how about a browser that’sprivacy-orientedand feature-rich? It won’t cost you anything but some time to install and try.

Besides, the browser is customizable to fit various needs, thanks to the extensive add-on support and it comes with a built-in AI.

Opera One

2. Remove #Ref! errors

Excel will display a notice known as a #REF error if a formula makes reference to a cell that does not now exist. This is typically the result of removing cells that a calculation is referring to.

Fixing your #REF errors is likely to solve the We’re sorry we can’t open the workbook in the browser error.

Launch Excel and open the problematic workbook.

2.PressCtrl+Fthen click theReplacetab.

Type#REF!inside theFind whatfield.
Leave theReplacefield empty.

5.Finally, clickReplace All.The function will delete all #REF Excel errors and thus fix the issue.

Usually, some parts of the file are not supported for sharing, but you should still be able to show the central part of the file in the web-based application.

However, you need to enable sharing for the said file before we can access it online. This option is disabled by default, and you should allow it for an Excel sheet or SharePoint file to be accessible online.

With this, you should be able to fix the error that couldn’t open the workbook in Excel Online.

4. Edit a copy instead of the original file

Finally, you can try editing the file copy instead of the original file. That allowed some users to access the file online, even though it still might not work in the likes of Chrome or Firefox, so have that in mind. Again, you choose to edit the copy, which should help.

Once the error appears, click Edit a copy, and you can merge everything locally. Don’t forget to use a different name, or the original file will be replaced upon saving otherwise.

The solutions are also effective if you are experiencing the following errors:

With that said, we can conclude this article. If you have any questions or alternative workarounds, feel free to tell us in the comments below.

We’re Sorry, Can’t Open The Workbook in The Browser (Excel): Fixed#

Why won’t Excel open in the browser?#

How can I fix the Sorry we can’t open your workbook in Excel online error?#

1. Try with a different browser#

Opera One#

2. Remove #Ref! errors#

3. Turn on Sharing#

4. Edit a copy instead of the original file#