Home

Excel "browser view" does not work in Excel tab in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-363198%22%20slang%3D%22en-US%22%3EExcel%20%22browser%20view%22%20does%20not%20work%20in%20Excel%20tab%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363198%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20added%20an%20Excel%20tab%20to%20my%20Teams%20channel.%20When%20I%20go%20to%20the%20tab%20I%20can%20see%20it%20is%20opening%20it%20in%20Excel%20Online.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20when%20I%20change%20the%20browser%20view%20settings%20in%20my%20Excel%20sheet%20to%20Gallery%20View%2C%20then%20the%20view%20in%20tab%20in%20Teams%20does%20not%20change%2C%20whilst%20when%20opening%20the%20same%20file%20in%20any%20browser%20or%20in%20SharePoint%20it%20does%20show%20the%20Gallery%20View.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363198%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-368336%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20%22browser%20view%22%20does%20not%20work%20in%20Excel%20tab%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368336%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%3BExcel%20Online%20tab%20in%20Teams%20opens%20in%20Editing%20View%20by%20default%20it%20seems.%20The%26nbsp%3BExcel%20browser%26nbsp%3Bviews%2C%20like%20the%20gallery%20view%2C%26nbsp%3Bis%20only%20visible%20in%20Reading%20View.%3C%2FP%3E%3CP%3EThis%20changing%20this%20setting%20is%20not%20yet%20possible%20in%20Teams.%20See%20this%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint%2FDefault-view-mode-edit-mode-behavior-for-Word-and-Excel-Online%2Ftd-p%2F226287%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Eblog%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363209%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20%22browser%20view%22%20does%20not%20work%20in%20Excel%20tab%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363209%22%20slang%3D%22en-US%22%3EYeah!%20The%20tabs%20in%20teams%20works%20on%20it%E2%80%99s%20own%20terms!%3C%2FLINGO-BODY%3E
Edwin1812
New Contributor
Hi!

I have added an Excel tab to my Teams channel. When I go to the tab I can see it is opening it in Excel Online.

However, when I change the browser view settings in my Excel sheet to Gallery View, then the view in tab in Teams does not change, whilst when opening the same file in any browser or in SharePoint it does show the Gallery View.
2 Replies
Highlighted
Yeah! The tabs in teams works on it’s own terms!
Highlighted

@adam deltinger Excel Online tab in Teams opens in Editing View by default it seems. The Excel browser views, like the gallery view, is only visible in Reading View.

This changing this setting is not yet possible in Teams. See this blog

Related Conversations
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
1 Replies
everything is black and white in excel
Gold4trees in Excel on
2 Replies