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
Highlighted

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?

 

 

Highlighted

Nope, unfortunately have no idea how to fix.

Related Conversations
Resizing table Error
birkettsl in Excel on
0 Replies
Conditional formatting assistance please
c_frndz in Excel on
0 Replies
delete one marging
fred83 in Excel on
3 Replies
Link Sheet 2 to Sheet 1 but 'only' if........
WhopRBopr1 in Excel on
3 Replies
Database Structure
leuki in Excel on
0 Replies