Sharing in Excel Online in OneDrive - Pivot table slicers don't appear in Android web browser

%3CLINGO-SUB%20id%3D%22lingo-sub-109730%22%20slang%3D%22en-US%22%3ESharing%20in%20Excel%20Online%20in%20OneDrive%20-%20Pivot%20table%20slicers%20don't%20appear%20in%20Android%20web%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109730%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20a%20strange%20problem%20with%20Excel%20online%2C%20and%20here%20is%20my%20example%20sheet%20for%20you%20to%20try%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2F1drv.ms%2Fx%2Fs!AhTZr-GdLCi2aRKYt60Nt5j7cT0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2F1drv.ms%2Fx%2Fs!AhTZr-GdLCi2aRKYt60Nt5j7cT0%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20browser%20on%20a%20desktop%20computer%20(in%20my%20case%20Chrome)%20it%20looks%20like%20this%2C%20and%20the%20slicers%20work%20as%20they%20are%20meant%20to%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F20724i62FE5777206842DC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22slicerPC.PNG%22%20title%3D%22slicerPC.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20open%20the%20same%20link%20on%20my%20Android%20phone%20(Samsung%20Galaxy%20S5%2C%20Chrome)%20the%20slicers%20don't%20appear%2C%20and%20there%20is%20no%20placeholder%20like%20you%20sometimes%20get%20when%20slicers%20don't%20render%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20603px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F20725i9B8BD7E9EA6CF237%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22slicerPhone.PNG%22%20title%3D%22slicerPhone.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20are%20the%20slicers%20not%20displaying%20on%20mobile%2C%20and%20what%20can%20I%20do%20to%20fix%20the%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20contrast%2C%20if%20you%20choose%20to%20open%20the%20file%20in%20'Excel'%20on%20the%20mobile%2C%20which%20is%20the%20mobile%20Excel%20Android%20app%20as%20opposed%20to%20Excel%20Online...%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20458px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F20729i591F6CF5DD127BCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sliceropen.PNG%22%20title%3D%22sliceropen.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...you%20get%20the%20following%20warning%20becase%20slicers%20aren't%20supported%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20495px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F20727iF5554F2EF3D9D39E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22slicerwarning.PNG%22%20title%3D%22slicerwarning.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20all%20very%20confusing.%20What%20I%20don't%20understand%20is%20why%20slicers%20won't%20appear%20when%20viewed%20in%20browser%20on%20my%20mobile%20phone.%20On%20my%20Android%20tablet%20the%20slicers%20appear%20to%20work%20fine%2C%20using%20the%20same%20link!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-109730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharing%20%26amp%3B%20Publishing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209458%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20in%20Excel%20Online%20in%20OneDrive%20-%20Pivot%20table%20slicers%20don't%20appear%20in%20Android%20web%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209458%22%20slang%3D%22en-US%22%3EI%20also%20would%20like%20to%20know%20a%20solution%20to%20this%20particular%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159662%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20in%20Excel%20Online%20in%20OneDrive%20-%20Pivot%20table%20slicers%20don't%20appear%20in%20Android%20web%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159662%22%20slang%3D%22en-US%22%3E%3CP%3EI'd%20also%20like%20to%20find%20a%20solution%20to%20this%20problem%20and%20am%20disappointed%20that%20none%20has%20been%20offered%20to%20this%205-%20month%20old%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1183747%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20in%20Excel%20Online%20in%20OneDrive%20-%20Pivot%20table%20slicers%20don't%20appear%20in%20Android%20web%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1183747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F80506%22%20target%3D%22_blank%22%3E%40johnrtullis%3C%2FA%3E%26nbsp%3BHas%20this%20issue%20been%20resolved%3F%20I'm%20also%20interested%20in%20using%20pivot%20slicer%20functionality%20when%20opening%20Excel%20attachments%20in%20OneDrive%20on%20an%20Android%20device.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm having a strange problem with Excel online, and here is my example sheet for you to try:

 

https://1drv.ms/x/s!AhTZr-GdLCi2aRKYt60Nt5j7cT0

 

In a browser on a desktop computer (in my case Chrome) it looks like this, and the slicers work as they are meant to:

slicerPC.PNG

 

However, when I open the same link on my Android phone (Samsung Galaxy S5, Chrome) the slicers don't appear, and there is no placeholder like you sometimes get when slicers don't render:

slicerPhone.PNG

 

Why are the slicers not displaying on mobile, and what can I do to fix the problem?

 

By contrast, if you choose to open the file in 'Excel' on the mobile, which is the mobile Excel Android app as opposed to Excel Online... 

sliceropen.PNG 

 

...you get the following warning becase slicers aren't supported:

slicerwarning.PNG

 

It's all very confusing. What I don't understand is why slicers won't appear when viewed in browser on my mobile phone. On my Android tablet the slicers appear to work fine, using the same link! 

 

Thanks

4 Replies

I'd also like to find a solution to this problem and am disappointed that none has been offered to this 5- month old post.

I also would like to know a solution to this particular problem.

@johnrtullis Has this issue been resolved? I'm also interested in using pivot slicer functionality when opening Excel attachments in OneDrive on an Android device.

Upvote. I can see it in google chrome on my phone but not in the app itself. Please help.