Home

Teams crashes when editing Excel file by "Open in Desktop App"

%3CLINGO-SUB%20id%3D%22lingo-sub-804108%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804108%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20get%20this%20on%20multiple%20computers%20or%20only%20one%20computer%3F%20Can%20you%20try%20to%20uninstall%20Teams%20and%20clear%20cache%20on%20your%20computer%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblog.valeconsulting.co.uk%2F2018%2F09%2F28%2Fclear-the-microsoft-teams-client-cache%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.valeconsulting.co.uk%2F2018%2F09%2F28%2Fclear-the-microsoft-teams-client-cache%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804153%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804153%22%20slang%3D%22en-US%22%3EWonder%20if%20this%20is%20related%20to%20Teams%20at%20all...try%20opening%20the%20file%20from%20SharePoint%20to%20the%20desktop%20app%20instead%20and%20see%20if%20this%20is%20the%20same%20behavior.%3CBR%20%2F%3EIs%20it%20one%20file%20only%20or%20all%20excel%20files%3F%20And%20as%20Linus%20said%2C%20does%20this%20happen%20for%20several%20users%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804806%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804806%22%20slang%3D%22en-US%22%3EHi%2C%20As%20Adam%20suggested%2C%20can%20you%20open%20the%20file%20in%20SharePoint%3F%20Can%20you%20download%20the%20file%20to%20your%20desktop%20and%20edit%20the%20file%3F%20If%20you%20can%20edit%20the%20downloaded%20file%2C%20try%20this...%20Click%20on%20Start%20Menu%20and%20type%20'upload'%20and%20select%20Office%20Upload%20Center%2C%20select%20Settings%20and%20select%20Delete%20Cache%20Files%2C%20See%20if%20this%20will%20resolve%20your%20issue.%20Regards%2C%20Anthony%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-805166%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F317260%22%20target%3D%22_blank%22%3E%40zhiyuan_chen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20test%20to%20see%20if%20it's%20really%20the%20Teams%20application%20is%20to%20open%20Teams%20from%20your%20browser%20and%20try%20and%20open%20the%20file%20from%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it's%20def%20the%20app%20and%20all%20of%20the%20other%20suggestions%20don't%20work%2C%20you%20might%20want%20to%20open%20a%20ticket%20with%20MS.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806252%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20received%20this%20feedback%20from%20several%20of%20my%20users.%3C%2FP%3E%3CP%3ETried%20cache%20clear%20and%20Teams%26nbsp%3Breinstall.%20But%20the%20Teams%20app%20crash%20problem%20remains%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806253%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806253%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20received%20this%20feedback%20from%20several%20of%20my%20users.%3CBR%20%2F%3ETried%20cache%20clear%20and%20Teams%20reinstall.%20But%20the%20Teams%20app%20crash%20problem%20remains%20the%20same.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806257%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806257%22%20slang%3D%22en-US%22%3EIt%20happens%20to%20several%20users.%20I'm%20not%20sure%20if%20all%20excel%20files%20has%20this%20problem%2C%20but%20I%20can%20reproduce%20it%20by%20just%20using%20a%20newly%20created%20blank%20excel%20file.%3CBR%20%2F%3EI%20have%20tried%20open%20excel%20file%20from%20the%20SharePoint%20Online%20site%20connected%20to%20my%20team.%20Yes%2C%20in%20this%20way%20Teams%20desktop%20app%20won't%20get%20crashed%20and%20everything%20works%20correctly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806259%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806259%22%20slang%3D%22en-US%22%3ESure%20we%20can%20download%20the%20file%20to%20local%20desktop%20and%20edit.%20Selected%20Delete%20Cache%20Files%20in%20Office%20Upload%20Center%20as%20you%20instructed%20but%20still%20cannot%20solve%20the%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806264%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806264%22%20slang%3D%22en-US%22%3EIf%20open%20the%20file%20from%20Teams%20web%20app%2C%20the%20crash%20issue%20will%20not%20happen.%20So%20I%20think%20it%20can%20be%20sure%20that%20it%20's%20the%20Teams%20app's%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806284%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806284%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20for%20giving%20suggestions.%3C%2FP%3E%3CP%3EI%20have%20done%20several%20tests%20and%20found%20the%20way%20to%20reproduce%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20create%20a%20blank%20excel%20file%20and%20upload%20to%20any%20team%20you%20like.%3C%2FP%3E%3CP%3E2.%20open%20the%20file%20from%20File%20tab%20by%20using%20%22Open%20in%20desktop%20app%22%3C%2FP%3E%3CP%3E3.%20when%20file%20opened%20in%20Excel%20Desktop%2C%20edit%20it%20freely%20-%26gt%3B%20save%20and%20close%20the%20file%3C%2FP%3E%3CP%3E(if%20your%20Office%20desktop%20is%20Office2013%2F2016%20MSI%2C%20you%20may%20get%20a%20windows%20prompted%20up%20to%20ask%20you%20to%20open%20the%20file%20twice...%20Anyway%2C%20that%20is%20another%20problem.)%3C%2FP%3E%3CP%3E4.%20repeat%20Step3%20several%20times.%20When%20the%205th%20or%206th%20time%20you%20do%20Step3%2C%20you%20can%20get%20your%20Teams%20app%20crashed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806741%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806741%22%20slang%3D%22en-US%22%3EDo%20you%20get%20any%20error%20messages%3F%20for%20your%20step%203%20-%20excel%20file%20open%20twice%2C%20there%20is%20a%20post%20and%20here%20is%20the%20link%20-%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FTeams-desktop-app-opens-documents-twice%2Fm-p%2F739032%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FTeams-desktop-app-opens-documents-twice%2Fm-p%2F739032%3C%2FA%3EAnd%20my%20company%20has%20open%20a%20ticket%20with%20Microsoft.%20Will%20post%20resolution%20when%20it%20is%20resolve%20by%20Microsoft.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807094%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807094%22%20slang%3D%22en-US%22%3EHi%20Zhiyuan%2C%20Able%20to%20reproduce%20your%20error.%20I%20opened%20and%20closed%20a%20combination%20of%20Word%20and%20Excel%20documents%20and%20at%20the%206th%20time%20when%20the%20Office%20app%20try%20to%20open%20the%20doc%20by%20itself%20after%20I%20closed%2C%20Teams%20crashes.%20I%20was%20able%20to%20recreate%20the%20crash%20consistently%20on%20the%206th%20time.%20I%20will%20update%20my%20ticket%20with%20Microsoft%20with%20this%20additional%20issue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807690%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807690%22%20slang%3D%22en-US%22%3EI'm%20also%20contacting%20with%20MS%20about%20this%20issue.%20Hope%20they%20can%20find%20out%20the%20reason.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804019%22%20slang%3D%22en-US%22%3ETeams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804019%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20described%20in%20topic%2C%20I%20found%20that%20there%20is%20possibility%20that%20Teams%20may%20get%20crashed%20when%20editing%20Excel%20file%20shared%20in%20team%20by%20using%20%22Open%20in%20Desktop%20App%22.%3C%2FP%3E%3CP%3ENot%20each%20time%20your%20do%20such%20operation%20can%20get%20Teams%20crashed%2C%20but%20it%20is%20about%201%20out%20of%2010%20trials%20may%20get%20this%20happened.%3C%2FP%3E%3CP%3EI%20just%20wonder%20if%20anyone%20here%20has%20met%20the%20same%20problem%20and%20if%20there%20is%20any%20method%20to%20solve%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20environment%3C%2FP%3E%3CP%3EOS%3A%20Win10%3C%2FP%3E%3CP%3EOffice%3A%20Office%26nbsp%3B%20professional%20plus%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-804019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807695%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807695%22%20slang%3D%22en-US%22%3ELet%20us%20know%20how%20it%20goes!!%20I%E2%80%99ll%20try%20reproduce%20also!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-812077%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20about%20your%20result%3F%3C%2FP%3E%3CP%3EI%20got%20reply%20from%20MS%20that%20they%20cannot%20reproduce%20this%20case%20in%20their%20environment.%20I%20want%20to%20know%20if%20anyone%20else%20can%20reproduce%20this%20issue.%20At%20least%20I%20can%20trigger%20the%20problem%20consistently%20on%20my%20Win10%20and%20Win7%20PC%2C%20both%20with%20MS%20Office%20professional%20plus%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-812423%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20crashes%20when%20editing%20Excel%20file%20by%20%22Open%20in%20Desktop%20App%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392795%22%20target%3D%22_blank%22%3E%40zhiyuanChen%3C%2FA%3E%26nbsp%3BI%20followed%20your%20steps%20and%20opened%20and%20edited%2010%20times%20without%20any%20problem.%20But%20I%20run%20Office%20356%20ProPlus%20and%20not%20the%20Office%202013%20edition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20to%20disable%20Add-ins%20in%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
zhiyuan_chen
New Contributor

As described in topic, I found that there is possibility that Teams may get crashed when editing Excel file shared in team by using "Open in Desktop App".

Not each time your do such operation can get Teams crashed, but it is about 1 out of 10 trials may get this happened.

I just wonder if anyone here has met the same problem and if there is any method to solve it.

 

My environment

OS: Win10

Office: Office  professional plus 2013

 

15 Replies

Hi,

 

Do you get this on multiple computers or only one computer? Can you try to uninstall Teams and clear cache on your computer?

https://blog.valeconsulting.co.uk/2018/09/28/clear-the-microsoft-teams-client-cache/

Wonder if this is related to Teams at all...try opening the file from SharePoint to the desktop app instead and see if this is the same behavior.
Is it one file only or all excel files? And as Linus said, does this happen for several users?
Hi, As Adam suggested, can you open the file in SharePoint? Can you download the file to your desktop and edit the file? If you can edit the downloaded file, try this... Click on Start Menu and type 'upload' and select Office Upload Center, select Settings and select Delete Cache Files, See if this will resolve your issue. Regards, Anthony

@zhiyuan_chen 

 

Another test to see if it's really the Teams application is to open Teams from your browser and try and open the file from there.

 

If it's def the app and all of the other suggestions don't work, you might want to open a ticket with MS.

@Linus Cansby

I have received this feedback from several of my users.
Tried cache clear and Teams reinstall. But the Teams app crash problem remains the same.
It happens to several users. I'm not sure if all excel files has this problem, but I can reproduce it by just using a newly created blank excel file.
I have tried open excel file from the SharePoint Online site connected to my team. Yes, in this way Teams desktop app won't get crashed and everything works correctly.
Sure we can download the file to local desktop and edit. Selected Delete Cache Files in Office Upload Center as you instructed but still cannot solve the problem.
If open the file from Teams web app, the crash issue will not happen. So I think it can be sure that it 's the Teams app's problem.

Thank you very much for giving suggestions.

I have done several tests and found the way to reproduce the problem.

 

1. create a blank excel file and upload to any team you like.

2. open the file from File tab by using "Open in desktop app"

3. when file opened in Excel Desktop, edit it freely -> save and close the file

(if your Office desktop is Office2013/2016 MSI, you may get a windows prompted up to ask you to open the file twice... Anyway, that is another problem.)

4. repeat Step3 several times. When the 5th or 6th time you do Step3, you can get your Teams app crashed.

 

 

Do you get any error messages? for your step 3 - excel file open twice, there is a post and here is the link - https://techcommunity.microsoft.com/t5/Microsoft-Teams/Teams-desktop-app-opens-documents-twice/m-p/7... And my company has open a ticket with Microsoft. Will post resolution when it is resolve by Microsoft.
Hi Zhiyuan, Able to reproduce your error. I opened and closed a combination of Word and Excel documents and at the 6th time when the Office app try to open the doc by itself after I closed, Teams crashes. I was able to recreate the crash consistently on the 6th time. I will update my ticket with Microsoft with this additional issue
I'm also contacting with MS about this issue. Hope they can find out the reason.
Let us know how it goes!! I’ll try reproduce also!

@adam deltinger 

How about your result?

I got reply from MS that they cannot reproduce this case in their environment. I want to know if anyone else can reproduce this issue. At least I can trigger the problem consistently on my Win10 and Win7 PC, both with MS Office professional plus 2013

 

@zhiyuanChen I followed your steps and opened and edited 10 times without any problem. But I run Office 356 ProPlus and not the Office 2013 edition.

 

Have you tried to disable Add-ins in Excel?