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
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

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?

 

 

Nope, unfortunately have no idea how to fix.