Home

'Can't open workbook' error in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-71331%22%20slang%3D%22en-US%22%3E'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F14830i89D8C65BAE2EAEDF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Teams%20error.png%22%20title%3D%22Teams%20error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20created%20a%20new%20Excel%20document%20in%26nbsp%3BFiles%20and%20then%20created%20a%20tab%20linking%20to%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20click%20on%20the%20tab%2C%20the%20Excel%20file%20is%20not%20displayed%20in%20the%20window.%20Instead%20I%20receieve%20'can't%20open%20workbook'%20message%20(see%20attached%20image).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20make%20sense%20how%20the%20'file%20format'%20can%20be%20wrong%2C%20seeing%20as%20the%20file%20was%20created%20in%20Teams.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-71331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215379%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215379%22%20slang%3D%22en-US%22%3E%3CP%3ECreating%20a%20tab%20as%20an%20excel%20document%20and%26nbsp%3Bselecting%20an%20excel%20file%20I%20had%20uploaded%20to%20the%20channel%20gave%20me%20the%20%22Can't%20open%20workbook%22%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20followed%20the%20suggestion%20to%20instead%20go%20into%26nbsp%3Bthe%20Channels%20files%2C%20clicked%20the%20ellipses%20to%20the%20right%20and%20selected%20%22Make%20this%20a%20tab%22%20and%20it%20worked!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213412%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213412%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20RMB%20on%20the%20Excel%20file%20under%20a%20CHANNEL%2FFILES%2FExcel-SS.xlsx%2C%20and%20then%20choose%20the%20MAKE%20A%20THIS%20A%20TAB%20menu%20pick%2C%20and%20it%20will%20create%20a%20working%20Tab%20to%20this%20excel%20file%20that%20launches%20Excel%20on%20this%20workbook.%26nbsp%3B%26nbsp%3B%20Starting%20from%20a%20TAB%20and%20then%20linking%20to%20a%20SS%20doesnt%20seem%20to%20work%2C%20which%20is%20why%20I%20worked%20this%20issue%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213407%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213407%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20create%20a%20Tab%20(under%20a%20channel)%2C%20and%20then%20associated%20that%20with%20an%20Excel%20file%20stored%20within%20a%20Teams%20File%20channel%2C%20it%20gives%20an%20error%3A%20%22Unknown%20Error%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20put%20the%20Excel%20file%20under%20a%20Channel's%20folder%2C%20say%20called%20EXCELS%20(or%20whatever)%2C%20and%20then%20RMB%20on%20the%20Excel%20SS%20file%2C%20you%20will%20see%20a%20menu%20pick%20%22Make%20This%20A%20Tab%22.%26nbsp%3B%26nbsp%3B%20This%20will%20create%20a%20Tab%20with%20the%20SS%20file%20name%20(which%20you%20can%20rename)%20that%20does%20work%20and%20opens%20the%20Excel%20SS.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20it%20appears%20that%20letting%20TEAM%20make%20the%20Tab%20linkage%20from%20the%20file%20works%2C%20making%20the%20Tab%20and%20linking%20to%20a%20SS%20doesnt.%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Probably%20a%20bug%20or%20flow%20methodology%20issue%20as%20implemented.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-125373%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125373%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20anybody%20ever%20find%20a%20solution%20for%20this%3F%20I%20have%20a%20client%20who%20is%20witnessing%20these%20same%20issues.%20WHen%20trying%20to%20open%20a%20excel%20file%2C%20it%20returns%20a%20(translated)%20message%20that%20sounds%20a%20bit%20like%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%22%3CEM%3EWe%20are%20unable%20to%20open%20the%20workbook%20file%20in%20this%20browser%20due%20to%20the%20following%20non-supported%20actions%3A%20%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%26nbsp%3B-%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Sharing%20of%20workbook%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EWould%20you%20like%20to%20open%20the%20file%20in%20Excel%3F%3C%2FEM%3E%22%3CBR%20%2F%3E%3CBR%20%2F%3EHas%20anybody%20else%20had%20this%20happen%20-%20and%20do%20you%20have%20a%20solution%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111980%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111980%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20here.%20Uploaden%20a%20workbook%20works%20fine%2C%20but%20creating%20a%20new%20workbook%20gives%20some%20issues.%20Sometimes%20the%20workbook%20cannot%20be%20opened%20with%20%22Wrong%20file%20format%20message%22%20on%20other%20ocassions%20we%20can%20open%20it%2C%20but%20it%20remains%20open%2C%20even%20if%20alle%20windows%20are%20closed.%20When%20openeing%20by%20another%20person%20he%20gets%20an%20error%20that%20the%20file%20is%20allready%20open%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71622%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71622%22%20slang%3D%22en-US%22%3ENever%20have%20this%20kind%20of%20problems%20when%20working%20with%20Excel%20or%20any%20of%20the%20other%20Office%20products%20in%20Tams%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71352%22%20slang%3D%22en-US%22%3ERe%3A%20'Can't%20open%20workbook'%20error%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71352%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20tried%20creating%20a%20new%20Excel%20and%20then%20adding%20the%20tab%20and%20it%20worked.%20So%20I%20wonder%20if%20there%20is%20somehting%20in%20the%20content%20of%20your%20excel%20file%20that%20isn't%20supported%20by%20the%20previewer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20you%20be%20able%20to%20share%20some%20information%20about%20the%20contents%20of%20the%20spreadsheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Llywelyn Morgan
Contributor

Teams error.png

I created a new Excel document in Files and then created a tab linking to it.

 

When I click on the tab, the Excel file is not displayed in the window. Instead I receieve 'can't open workbook' message (see attached image).

 

It doesn't make sense how the 'file format' can be wrong, seeing as the file was created in Teams.

 

 

7 Replies

I just tried creating a new Excel and then adding the tab and it worked. So I wonder if there is somehting in the content of your excel file that isn't supported by the previewer.

 

Would you be able to share some information about the contents of the spreadsheet?

Never have this kind of problems when working with Excel or any of the other Office products in Tams

Same issue here. Uploaden a workbook works fine, but creating a new workbook gives some issues. Sometimes the workbook cannot be opened with "Wrong file format message" on other ocassions we can open it, but it remains open, even if alle windows are closed. When openeing by another person he gets an error that the file is allready open

Did anybody ever find a solution for this? I have a client who is witnessing these same issues. WHen trying to open a excel file, it returns a (translated) message that sounds a bit like:

"We are unable to open the workbook file in this browser due to the following non-supported actions:
 -    Sharing of workbook
Would you like to open the file in Excel?"

Has anybody else had this happen - and do you have a solution for this?

Highlighted

If you create a Tab (under a channel), and then associated that with an Excel file stored within a Teams File channel, it gives an error: "Unknown Error"

 

If you put the Excel file under a Channel's folder, say called EXCELS (or whatever), and then RMB on the Excel SS file, you will see a menu pick "Make This A Tab".   This will create a Tab with the SS file name (which you can rename) that does work and opens the Excel SS.  

 

So it appears that letting TEAM make the Tab linkage from the file works, making the Tab and linking to a SS doesnt.    Probably a bug or flow methodology issue as implemented.

Try RMB on the Excel file under a CHANNEL/FILES/Excel-SS.xlsx, and then choose the MAKE A THIS A TAB menu pick, and it will create a working Tab to this excel file that launches Excel on this workbook.   Starting from a TAB and then linking to a SS doesnt seem to work, which is why I worked this issue

Creating a tab as an excel document and selecting an excel file I had uploaded to the channel gave me the "Can't open workbook" error.

 

I followed the suggestion to instead go into the Channels files, clicked the ellipses to the right and selected "Make this a tab" and it worked!  

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies