SOLVED

Unable to add Excel Tab to Channel

%3CLINGO-SUB%20id%3D%22lingo-sub-117942%22%20slang%3D%22en-US%22%3EUnable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-117942%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20unable%20to%20add%20an%20Excel%20tab%20to%20a%20Channel.%26nbsp%3B%20The%20Excel%20dialog%20box%20displays%2C%20I%20add%20a%20name%20and%20a%20green%20check%20appears%20but%20the%20Save%20button%20remains%20grayed%20out.%26nbsp%3B%20Only%20the%20Back%20button%20is%20available.%26nbsp%3B%20I've%20tried%20on%20the%20desktop%20app%20and%20browser.%26nbsp%3B%20Anyone%20have%20a%20solution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-117942%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-354780%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354780%22%20slang%3D%22en-US%22%3EThis%20was%20what%20was%20preventing%20me%20from%20adding%20a%20new%20Word%20tab%3B%20adding%20the%20file%20first%20then%20selecting%20it%20solved%20it%2C%20thanks!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-136032%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136032%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Steven%2C%20I%20understand%20what%20I%20was%20doing%20wrong.%26nbsp%3B%20It%20appears%20that%20one%20has%20to%20first%20add%20an%20Excel%20file%20to%20a%20Files%20tab%20and%20then%20the%20Excel%20Tab%20can%20be%20added%20by%20selecting%20the%20excel%20file%20previously%20added.%20Suggestion%20is%20to%20allow%20the%20addition%20of%20the%20file%20while%20creating%20the%20Excel%20tab%20as%20that%20does%20not%20appear%20to%20be%20an%20option%20today.%26nbsp%3B%20It%20is%20not%20intuitive%20to%20have%20a%20tab%20called%20Files%20to%20post%20files%20and%20have%20something%20similar%20by%20file%20type%20like%20Word%2C%20Excel%20etc.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-135990%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-135990%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20the%20same%20error%20message%20when%20I%20tried%20adding%20an%20Excel%20tab%20when%20the%20file%20was%20not%20an%20.xlsx%20file.%26nbsp%3B%20In%20my%20case%20I%20was%20trying%20to%20add%20a%20.CSV.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793772%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F288818%22%20target%3D%22_blank%22%3E%40Jordan_00%3C%2FA%3E%26nbsp%3BI%20had%20added%20mine%20first%2C%20then%20moved%20the%20file%20to%20a%20tab.%20That%20worked%20and%20they%20were%20there%20for%20a%20while.%20I%20come%20back%20from%20lunch%20and%20any%20%22private%22%20channel%2C%20every%20customized%20tab%20has%20gone%20away.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-991639%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-991639%22%20slang%3D%22en-US%22%3E%3CP%3EI%20joined%20this%20forum%20to%20ask%20this%20very%20question%2C%20and%20you%20lot%20have%20answered%20it%20for%20me%20thank%20you.%3C%2FP%3E%3CP%3EHowever%2C%20it%20seems%20pointless%20to%20have%20tabs%20for%20'word'%20and%20'excel'%20as%20they%20only%20present%20one%20document.%3C%2FP%3E%3CP%3ESurely%20its%20much%20easier%20to%20browse%20the%20'files'%20tab%20so%20you%20have%20all%20your%20word%20and%20excel%20files%20to%20hand.%3C%2FP%3E%3CP%3EI%20thought%20the%20'word'%20tab%20would%20give%20me%20a%20drop%20down%20of%20all%20the%20word%20docs%20associated%20with%20that%20channel.%3C%2FP%3E%3CP%3ETHAT%20to%20me%20would%20make%20much%20more%20sense.%3C%2FP%3E%3CP%3EWhat%20were%20MS%20thinking%20when%20they%20decided%20on%20this%20method%20I%20wonder%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1001632%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1001632%22%20slang%3D%22en-US%22%3ETrue%2C%20but%20it%20only%20lets%20you%20have%20one%20pinned%20file%20of%20each%20filetype%2C%20which%20is%20restrictive.%3CBR%20%2F%3EWe%20all%20tend%20to%20have%20multiple%20word%2C%20excel%20or%20pdf%20documents%20open%20at%20the%20same%20time%20when%20working%20with%20regular%20windows%20files%2Ffolders%20strucutres.%3CBR%20%2F%3EI'm%20finding%20Teams%20more%20restrictive%20by%20the%20day.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-992056%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20add%20Excel%20Tab%20to%20Channel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-992056%22%20slang%3D%22en-US%22%3EMy%20take%20on%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20an%20example%20-%20a%20customer%20care%20team%20have%20a%20tracking%20spreadsheet%20that%20they%20all%20need%20to%20monitor%20%2F%20update%20during%20the%20day.%20It%20makes%20sense%20to%20add%20a%20tab%20for%20that%20spreadsheet%2C%20so%20they%20essentially%20have%201%20click%20access%20to%20it%20at%20all%20times.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20same%20could%20be%20said%20for%20a%20reference%20document%20or%20PDF%20-%20think%20of%20it%20like%20a%20pinned%20file%20-%20but%20a%20pinned%20file%20that%20is%20already%20open%2C%20ready%20to%20be%20viewed%20or%20edited%20if%20needed.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am unable to add an Excel tab to a Channel.  The Excel dialog box displays, I add a name and a green check appears but the Save button remains grayed out.  Only the Back button is available.  I've tried on the desktop app and browser.  Anyone have a solution?

 

Thanks,

8 Replies
Highlighted

I had the same error message when I tried adding an Excel tab when the file was not an .xlsx file.  In my case I was trying to add a .CSV.

Highlighted
Solution

Hi Steven, I understand what I was doing wrong.  It appears that one has to first add an Excel file to a Files tab and then the Excel Tab can be added by selecting the excel file previously added. Suggestion is to allow the addition of the file while creating the Excel tab as that does not appear to be an option today.  It is not intuitive to have a tab called Files to post files and have something similar by file type like Word, Excel etc.

 

Thank you

Highlighted
This was what was preventing me from adding a new Word tab; adding the file first then selecting it solved it, thanks!
Highlighted

@Jordan_00 I had added mine first, then moved the file to a tab. That worked and they were there for a while. I come back from lunch and any "private" channel, every customized tab has gone away. 

Highlighted

I joined this forum to ask this very question, and you lot have answered it for me thank you.

However, it seems pointless to have tabs for 'word' and 'excel' as they only present one document.

Surely its much easier to browse the 'files' tab so you have all your word and excel files to hand.

I thought the 'word' tab would give me a drop down of all the word docs associated with that channel.

THAT to me would make much more sense.

What were MS thinking when they decided on this method I wonder?

Highlighted
My take on this:

As an example - a customer care team have a tracking spreadsheet that they all need to monitor / update during the day. It makes sense to add a tab for that spreadsheet, so they essentially have 1 click access to it at all times.

The same could be said for a reference document or PDF - think of it like a pinned file - but a pinned file that is already open, ready to be viewed or edited if needed.
Highlighted
True, but it only lets you have one pinned file of each filetype, which is restrictive.
We all tend to have multiple word, excel or pdf documents open at the same time when working with regular windows files/folders strucutres.
I'm finding Teams more restrictive by the day.
Highlighted

@Donna Edwards 

 

Thank you very much for this. This makes perfect sense that a file or document needs to be created first. I thought create a tab would automatically create a file for you.