Slicers not appearing for Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-1790704%22%20slang%3D%22en-US%22%3ESlicers%20not%20appearing%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790704%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20downloaded%20an%20Excel%20spreadsheet%20from%20a%20course%20I%20am%20taking%20online.%20I%20created%20a%20pivot%20table%20and%20chart%20as%20instructed%20by%20the%20instructor.%20The%20next%20step%20is%20to%20add%20slicers.%20I%20am%20not%20seeing%20the%20%22analyze%22%20or%20the%20%22slicer%22%20button%20anywhere.%20At%20one%20point%2C%20I%20think%20I%20did%20see%20the%20%22slicer%22%20action%20but%20it%20was%20greyed%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20option%20even%20available%20on%20Excel%20online%20%3F%20Where%20can%20I%20%22add%20on%22%20this%20feature.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1790704%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1791807%22%20slang%3D%22de-DE%22%3ESubject%3A%20Slicers%20not%20appearing%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1791807%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835512%22%20target%3D%22_blank%22%3E%40VF_17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExcel%20online%20has%20limited%20functionality%2C%20some%20commands%20are%20not%20available%20in%20this%20version.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Fexcel-online%23advanced-time-filtering-timeline-slicer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdvanced%20time%20filtering%20(Timeline%20slicer)%3C%2FA%3E%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ENot%20available%3C%2FSPAN%3E%3C%2FSPAN%3E%20Excel%20for%20the%20web%3C%2FP%3E%3CP%3EApplication%20features%3C%2FP%3E%3CP%3E1%20Cannot%20create%20PivotCharts%2C%20view%20only.%3C%2FP%3E%3CP%3E2%20Depending%20on%20how%20your%20environment%20is%20configured%2C%20some%20kinds%20of%20data%20connections%20are%20supported%20for%20workbooks%20displayed%20in%20Excel%20for%20the%20web.%20For%20more%20information%2C%20see%20Refreshing%20data%20in%20a%20workbook%20in%20a%20browser%20window.%3C%2FP%3E%3CP%3E3%20You%20cannot%20create%20or%20run%20macros%20with%20VBA%20in%20Excel%20for%20the%20web%2C%20but%20you%20can%20open%20and%20edit%20VBA-enabled%20spreadsheets%20without%20removing%20(or%20corrupting)%20the%20VBA%20contained%20in%20the%20file.%3C%2FP%3E%3CP%3E4%20In%20Excel%20for%20the%20web%2C%20the%20last%20known%20reference%20value%20displays%20in%20the%20browser%20window%3B%20However%2C%20it%20must%20be%20updated%20using%20the%20Excel%20desktop%20app.%3C%2FP%3E%3CP%3E5%20Some%2C%20but%20not%20all%2C%20Office%20add-ins%20are%20available.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Foffice-online-service-description%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Foffice-online-service-description%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all

 

I downloaded an Excel spreadsheet from a course I am taking online. I created a pivot table and chart as instructed by the instructor. The next step is to add slicers. I am not seeing the "analyze" or the "slicer" button anywhere. At one point, I think I did see the "slicer" action but it was greyed out.

 

Is this option even available on Excel online ? Where can I "add on" this feature. 

 

Thanks ! 

2 Replies
Highlighted

@VF_17 

Excel online has limited functionality, some commands are not available in this version.

 

Advanced time filtering (Timeline slicer) Not available Excel for the web

Application features

1 Cannot create PivotCharts, view only.

2 Depending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in Excel for the web. For more information, see Refreshing data in a workbook in a browser window.

3 You cannot create or run macros with VBA in Excel for the web, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file.

4 In Excel for the web, the last known reference value displays in the browser window; however, it must be updated using the Excel desktop app.

5 Some, but not all, Office add-ins are available.

https://docs.microsoft.com/en-us/office365/servicedescriptions/office-online-service-description/off...

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@VF_17 

Interface for working with PivotTable in Excel Online is slightly different from desktop version.

If you stay on PivotTable, this tab on ribbon shall appear

image.png

as well as right pane. If you hover the mouse on the field in right pane it will show that drop-down menu exists, click on arrow down at the right and from here you may add slicer

image.png

In addition, if you click Settings icon under PivotTable on ribbon, another right pane appears where you could play with PivotTable settings

image.png

 

Please note so far you can't add slicer for the Table in Excel Online, only for the PivotTable. Most probably this icon for Table you see on ribbon as greyed out. Forget about it for now, it do nothing.