Home

Automatically "Open in Excel?"

%3CLINGO-SUB%20id%3D%22lingo-sub-390136%22%20slang%3D%22en-US%22%3EAutomatically%20%22Open%20in%20Excel%3F%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390136%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20Excel%20file%20that%20is%20too%20large%20to%20open%20online%20that%20is%20shared%20among%20our%20members.%26nbsp%3B%20When%20we%20open%20it%2C%20we%20get%20the%20error%20that%20it%20is%20too%20large%20to%20open%20then%20there%20is%20an%20option%20to%20open%20in%20Excel.%26nbsp%3B%20We%20can%20right%20on%20the%20file%20to%20choose%20open%20in%20Excel.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20automatically%20open%20the%20file%20in%20Excel%20when%20Microsoft%20Teams%20starts%3F%3C%2FP%3E%3CP%3EAs%20second%20option%20is%20there%20a%20way%20to%20make%20it%20default%20opening%20in%20Excel%20or%20to%20automatically%20open%20in%20Excel%20if%20it%20can't%20open%20online%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3CBR%20%2F%3E%3CBR%20%2F%3EDan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-390136%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexcel%20files%3C%2FLINGO-LABEL%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-390147%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20%22Open%20in%20Excel%3F%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309853%22%20target%3D%22_blank%22%3E%40dxmkp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Dan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20what%20I%20can%20tell%2C%20technically%20yes%20there%20is%2C%20but%20it%20still%20requires%20a%20couple%20of%20clicks%20from%20the%20user%20so%20you%20don't%20really%20gain%20any%20efficiency%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20open%20the%20SharePoint%20site%20that%20houses%20the%20files.%20Go%20to%20the%20'gear'%20icon%20then%20Site%20Information%20-%20then%20Site%20Settings.%20Click%20Site%20Collection%20Features%20-%20locate%20'Open%20in%20Client%20Application'%20and%20click%20Activate.%20This%20will%20force%20all%20files%20stored%20on%20that%20SharePoint%20site%20to%20open%20in%20their%20client%20application%20instead%20of%20the%20Online%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20kicker%2C%20it%20still%20only%20works%20if%20they%20are%20opening%20the%20file%20via%20SharePoint.%20From%20the%20Team%2C%20Files%20tab%2C%20click%20Open%20in%20SharePoint.%20Then%20if%20they%20click%20directly%20on%20the%20file%2C%20it%20will%20open%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20probably%20just%20as%20easy%20to%20educate%20the%20user%20to%20right%20click%20then%20open%20the%20file%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
dxmkp
Occasional Visitor

We have an Excel file that is too large to open online that is shared among our members.  When we open it, we get the error that it is too large to open then there is an option to open in Excel.  We can right on the file to choose open in Excel.

Is there a way to automatically open the file in Excel when Microsoft Teams starts?

As second option is there a way to make it default opening in Excel or to automatically open in Excel if it can't open online?

 

Thank you!

Dan

1 Reply

@dxmkp 

Hi Dan,

 

From what I can tell, technically yes there is, but it still requires a couple of clicks from the user so you don't really gain any efficiency :(

 

You can open the SharePoint site that houses the files. Go to the 'gear' icon then Site Information - then Site Settings. Click Site Collection Features - locate 'Open in Client Application' and click Activate. This will force all files stored on that SharePoint site to open in their client application instead of the Online version.

 

Here's the kicker, it still only works if they are opening the file via SharePoint. From the Team, Files tab, click Open in SharePoint. Then if they click directly on the file, it will open in Excel.

 

It's probably just as easy to educate the user to right click then open the file in Excel. 

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 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
29 Replies