Home

Unable to open Excel file in Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-558660%22%20slang%3D%22en-US%22%3EUnable%20to%20open%20Excel%20file%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558660%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20open%20a%20excel%20file%20in%20Excel%20Online%20and%20that%20won't%20work.%20Errormessage%20is%20that%20due%20to%20%22view%20of%20formulas%20in%20the%20file%22%20the%20file%20cannot%20be%20opened%20in%20the%20browser.%20The%20only%20formulas%20are%20cells%20with%20date%20in%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20this%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ETheo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-558660%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558767%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Excel%20file%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558767%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340087%22%20target%3D%22_blank%22%3E%40icTheo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20comes%20to%20online%20Office%20%2F%20Excel%2C%20It%20all%20depends%20on%20the%20content%20of%20your%20excel%20file.%20Some%20features%2C%20such%20as%20VBA%20projects%20(macros)%20and%20XML%20maps%2C%20prevent%20a%20workbook%20from%20being%20opened%20at%20all%20in%20Excel%20Online.%26nbsp%3B%20When%20you%20try%20to%20view%20or%20edit%20a%20workbook%20like%20this%20in%20Excel%20Online%2C%20a%20message%20notifies%20you%20that%20the%20workbook%20can%E2%80%99t%20be%20opened%20in%20the%20browser.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20permission%20please%20edit%20the%20workbook%2C%20you%20can%20open%20the%20workbook%20in%20the%20Excel%20desktop%20application.%20If%20you%20see%20another%20message%20that%20says%20you%20don%E2%80%99t%20have%20a%20supported%20browser%20or%20the%20correct%20version%20of%20Excel%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fedit-a-workbook-that-contains-features-unsupported-by-excel-online-7220105d-97ad-4c35-95c8-58d4bbfd14af%23__you_get_an%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EI%20get%20an%20error%20message%20when%20I%20try%20to%20open%20the%20workbook%20in%20Excel.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20helps%20%2C%3C%2FP%3E%3CP%3EDav%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
icTheo
Occasional Visitor

I am trying to open a excel file in Excel Online and that won't work. Errormessage is that due to "view of formulas in the file" the file cannot be opened in the browser. The only formulas are cells with date in it. 

 

How can I make this work?

 

Best regards,

Theo

1 Reply
Highlighted

Hi @icTheo 

 

When it comes to online Office / Excel, It all depends on the content of your excel file. Some features, such as VBA projects (macros) and XML maps, prevent a workbook from being opened at all in Excel Online.  When you try to view or edit a workbook like this in Excel Online, a message notifies you that the workbook can’t be opened in the browser.

 

If you have permission please edit the workbook, you can open the workbook in the Excel desktop application. If you see another message that says you don’t have a supported browser or the correct version of Excel, see I get an error message when I try to open the workbook in Excel.

 

Hope it helps ,

Dav

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies