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

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?

 

 

Nope, unfortunately have no idea how to fix.

Related Conversations
Clear Pivot Table Cache during loop execution
ldbjr138 in Excel on
0 Replies
Sum by color
horton135 in Excel on
1 Replies
Get Stock Prices Function - Excel 365 on Mac
GW1980 in Excel on
2 Replies