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
help with formulae
Gavc1 in Excel on
1 Replies
print macro for variable print area
tomb999 in Excel on
0 Replies
Mailing worksheets in excel
Bruno1250 in Excel on
4 Replies
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies
Excel Worksheets and templates
Christine_R in Excel on
6 Replies