Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)

Make a file in MS teams only open in Desktop App

%3CLINGO-SUB%20id%3D%22lingo-sub-2165934%22%20slang%3D%22en-US%22%3EMake%20a%20file%20in%20MS%20teams%20only%20open%20in%20Desktop%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165934%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20an%20Excel%20sheet%20with%201%2F2%26nbsp%3B%20data%20for%20the%20whole%20team%20to%20see%20and%201%2F2%20only%20management%20to%20see.%20I%20have%20got%20this%20to%20work%20using%20macro%20code%20and%20password%20protecting%20the%20sensitive%20contents%20in%20the%20sheet.%20This%20document%20is%20intended%20to%20be%20a%20live%20document%20and%20live%20in%20Teams%20however%20when%20users%20open%20the%20file%20by%20default%20it%20opens%20in%20the%20web%20browser%20version%2C%20within%20teams%20which%20doesn't%20support%20the%20macro's%20therefore%20making%20all%20the%20content%20visible%20to%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20make%20this%20file%20open%20only%20in%20the%20Desktop%20app%20so%20that%20it%20works%20properly%3F%20Or%20is%20there%20any%20other%20way%20around%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2166139%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20file%20in%20MS%20teams%20only%20open%20in%20Desktop%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2166139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F978709%22%20target%3D%22_blank%22%3E%40Forrest505%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figured%20out%20this%20workaround...%3C%2FP%3E%3CP%3Eif%20you%20it%20the%20%22%2B%22%20and%20select%20Sharepoint%2Cany%20sharepoint%20site%20then%20paste%20a%20sharepoint%20URL%20in%20the%20following%20style...%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyourcompany.sharepoint.com%2Fsites%2Fsitename%2FShared%22%20rel%3D%22nofollow%20noreferrer%20noopener%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fyourcompany.sharepoint.com%2Fsites%2Fsitename%2FShared%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EDocuments%2FGeneral%3CBR%20%2F%3Eit%20will%20%22replicate%22%20the%20files%20tab%2C%20but%20all%20excel%20and%20word%20files%20will%20open%20in%20app%2C%20NOT%20Teams.%3C%2FP%3E%3CP%3Eyou%20can%20also%20add%20to%20the%20URL%20to%20use%20a%20subfolder%20if%20you%20want%3C%2FP%3E%3CP%3Eyou%20also%20need%20to%20make%20sure%20that%20the%20actual%20sharepoint%20site%20is%20setup%20to%20open%20in%20default%20apps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2168376%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20file%20in%20MS%20teams%20only%20open%20in%20Desktop%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2168376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F978823%22%20target%3D%22_blank%22%3E%40scottr23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Scott%2C%20will%20test%20this%20out%20now.%20Great%20workaround!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2168568%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20file%20in%20MS%20teams%20only%20open%20in%20Desktop%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2168568%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F978709%22%20target%3D%22_blank%22%3E%40Forrest505%3C%2FA%3E%26nbsp%3BThe%20biggest%20drawback%20is%20you%20lose%20functionality%20oy%20the%20%22...%22%20menu%2C%20but%20if%20opening%20word%20an%20excel%20files%20is%20the%20priority%2C%20then%20you%20should%20be%20pretty%20happy%20with%20it.%20I%20have%20been%20using%20it%20this%20way%20for%20several%20months%20in%20our%20organization.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I have an Excel sheet with 1/2  data for the whole team to see and 1/2 only management to see. I have got this to work using macro code and password protecting the sensitive contents in the sheet. This document is intended to be a live document and live in Teams however when users open the file by default it opens in the web browser version, within teams which doesn't support the macro's therefore making all the content visible to all.

 

Is there a way I can make this file open only in the Desktop app so that it works properly? Or is there any other way around this?

 

Many thanks

4 Replies

@Forrest505 

I figured out this workaround...

if you it the "+" and select Sharepoint,any sharepoint site then paste a sharepoint URL in the following style...
https://yourcompany.sharepoint.com/sites/sitename/Shared Documents/General
it will "replicate" the files tab, but all excel and word files will open in app, NOT Teams.

you can also add to the URL to use a subfolder if you want

you also need to make sure that the actual sharepoint site is setup to open in default apps.

@scottr23 

Thanks Scott, will test this out now. Great workaround!

@Forrest505 The biggest drawback is you lose functionality oy the "..." menu, but if opening word an excel files is the priority, then you should be pretty happy with it. I have been using it this way for several months in our organization.