Home

Excel Online Ribbon not visible on SP2016 xlsx file

%3CLINGO-SUB%20id%3D%22lingo-sub-369321%22%20slang%3D%22en-US%22%3EExcel%20Online%20Ribbon%20not%20visible%20on%20SP2016%20xlsx%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369321%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20Sharepoint%202016%20environment.%20Something%20strange%20happens%20when%20we%20open%20a%20XSLX%20file%20in%20Excel%20Online%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20277px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89154i95DCF60374AFAB1E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22xlsx%20online%20ribbon%20not%20showing.PNG%22%20title%3D%22xlsx%20online%20ribbon%20not%20showing.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20ribbon%20is%20not%20showing.%20I%20have%20tested%20this%20in%20Chrome%20and%20IE11.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20this%20only%20happens%20on%20XSLX%20files.%20An%20older%20XLS%20file%20opens%20Online%20and%20shows%20the%20ribbon.%26nbsp%3B%3C%2FP%3E%3CP%3EDocx%20files%20also%20open%20without%20issues.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369321%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eribbon%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%202016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369536%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Ribbon%20not%20visible%20on%20SP2016%20xlsx%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369536%22%20slang%3D%22en-US%22%3E%3CP%3ENope%2C%20unfortunately%20have%20no%20idea%20how%20to%20fix.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369498%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Ribbon%20not%20visible%20on%20SP2016%20xlsx%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369498%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20menu%20visible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20i%20have%20found%20the%20issue.%20Every%20DOM%20element%20of%20the%20ribbon%20is%20set%20to%20%22display%3A%20none%22%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20510px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89171i381733D7B5A176F0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22xlsx%20online%20ribbon%20not%20showing%202.PNG%22%20title%3D%22xlsx%20online%20ribbon%20not%20showing%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20strange%20thing%20is%2C%20that%20this%20does%20NOT%20happen%20with%20XLS%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20why%20this%20is%20happening%20and%20how%20to%20solve%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369438%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Ribbon%20not%20visible%20on%20SP2016%20xlsx%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369438%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20have%20a%20menu%20under%20the%20formula%20bar%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20590px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89166i0D7F7C4CD871F5D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20so%20you%20may%20click%20on%20any%20item%20and%20pin%20the%20ribbon%20with%20right%20bottom%20icon%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20237px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89167i67837ADB2536FE26%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Stefaan De Vreese
Occasional Contributor

We have a Sharepoint 2016 environment. Something strange happens when we open a XSLX file in Excel Online:

 

xlsx online ribbon not showing.PNG

 

the ribbon is not showing. I have tested this in Chrome and IE11. 

Also this only happens on XSLX files. An older XLS file opens Online and shows the ribbon. 

Docx files also open without issues.

 

Any help would be appreciated.

3 Replies

Do you have a menu under the formula bar?

image.png

If so you may click on any item and pin the ribbon with right bottom icon

image.png

Highlighted

No menu visible.

 

but i have found the issue. Every DOM element of the ribbon is set to "display: none":

 

xlsx online ribbon not showing 2.PNG

 

The strange thing is, that this does NOT happen with XLS files.

 

Any ideas on why this is happening and how to solve?

 

 

Highlighted

Nope, unfortunately have no idea how to fix.

Related Conversations
Solving Name conflict in excel
stanoh in Excel on
0 Replies
Macro to Import Information from Email Attachments into excel
calof1 in Excel on
0 Replies
i am stuck on vba and copying row based on value
tduff1460 in Excel on
1 Replies
Room Booking using Excel
Maddie1215 in Excel on
0 Replies
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies