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
Highlighted
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
Highlighted

@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
Repeating rows but not for entire sheet
RRPI-1997 in Excel on
2 Replies
IF function
qexle in Excel on
2 Replies
Excel Help needed
NojMc in Excel on
1 Replies
IFS with AND and multiple falses
Bradley79 in Excel on
1 Replies
Matching date input to the formatted date display
Erikstg in Excel on
2 Replies