SOLVED
Home

Excel Tab in Channel, only show certain/single sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-797685%22%20slang%3D%22en-US%22%3EExcel%20Tab%20in%20Channel%2C%20only%20show%20certain%2Fsingle%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797685%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20know%20of%20a%20way%20to%20display%20a%20single%20excel%20sheet%20on%20a%20Teams%20channel%20tab%20instead%20of%20an%20entire%20document%2C%20without%20hiding%20the%20sheets%20in%20the%20document%20itself%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20not%2C%20as%20the%20settings%20are%20all%20very%20simple%20and%20straightforward%20(and%20lacking%2C%20but%20it%20is%20what%20it%20is).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EChannel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797731%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Tab%20in%20Channel%2C%20only%20show%20certain%2Fsingle%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131202%22%20target%3D%22_blank%22%3E%40Myles%20Gallagher%3C%2FA%3E%26nbsp%3BIt%20is%20possible%20but%20it%20is%20not%20pretty%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20create%20a%20page%20and%20embed%20the%20File%20Viewer%20web%20part%20on%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20edit%20the%20properties%20for%20the%20web%20part%20and%20choose%20%22Range%22.%20Then%20You%20will%20be%20able%20to%20select%20a%20specific%20Sheet.%3C%2FP%3E%3CP%3ESave%20the%20Page%20and%20copy%20the%20url%20to%20it.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126416i39D3BC02C141E3F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FileViewer.JPG%22%20title%3D%22FileViewer.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOpen%20Your%20Team%20again%20and%20add%20a%20tab%20(of%20the%20type%20%22Website%22).%20Paste%20the%20Url%20and%20name%20the%20tab.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20result%20will%20look%20like%20this.%20Viewable%20but%20You%20will%20not%20be%20able%20to%20directly%20open%20it%20in%20Excel.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126417i48F73AE52C58AEF2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FileViewerViewInTeams.JPG%22%20title%3D%22FileViewerViewInTeams.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20i%20said%2C%20it%20is%20not%20pretty%20but%20it%20works%20if%20the%20purpose%20is%20just%20to%20display%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20was%20a%20good%20enough%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck!%3C%2FP%3E%3CP%3ERegards%2C%20Magnus%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797734%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Tab%20in%20Channel%2C%20only%20show%20certain%2Fsingle%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797734%22%20slang%3D%22en-US%22%3ENot%20gonna%20lie%2C%20even%20though%20it's%20so%20trivial%20that's%20pretty%20clever.%20Can't%20believe%20I%20didn't%20think%20of%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20is%20pretty%20clunk%20though!%20Thanks%20for%20the%20idea%2C%20much%20appreciated.%3C%2FLINGO-BODY%3E
Myles Gallagher
Contributor

Anyone know of a way to display a single excel sheet on a Teams channel tab instead of an entire document, without hiding the sheets in the document itself?

 

I suspect not, as the settings are all very simple and straightforward (and lacking, but it is what it is).

2 Replies
Solution

@Myles Gallagher It is possible but it is not pretty :)

 

You can create a page and embed the File Viewer web part on it. 

Then edit the properties for the web part and choose "Range". Then You will be able to select a specific Sheet.

Save the Page and copy the url to it.

FileViewer.JPG

Open Your Team again and add a tab (of the type "Website" or "SharePoint). Paste the Url (or select the Page) and name the tab. 

The result will look like this. Viewable but You will not be able to directly open it in Excel.

FileViewerViewInTeams.JPG

 

As i said, it is not pretty but it works if the purpose is just to display the data.

 

Hope that was a good enough answer.

 

Best of luck!

Regards, Magnus

 

Not gonna lie, even though it's so trivial that's pretty clever. Can't believe I didn't think of it.

It is pretty clunk though! Thanks for the idea, much appreciated.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies