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
Highlighted
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
Some useful resources
Tony Phillips in Microsoft Teams for Education on
0 Replies
Count Numbers and Quantities
JimDW2450 in Excel on
0 Replies
Password protect excel file on android
csobigc in Excel on
0 Replies
Still can't access calendar in Teams.
BartBr_PPCI in Microsoft Teams on
0 Replies
Average
Janedb in Excel on
5 Replies
Add Selected data 3D maps greyed out.
RobHoekstra in Excel on
0 Replies