Excel Pivot Table slicer (greyed out, add them to filter and remove)
Since Excel 2010, the new slicer has been added, it is mainly used to filter the data, it displays each field independently in a small window, when you select a field in one window, the options that belong to the selected field in another window will be filtered out, for example, select a category or a department, the options that belong to the category or department will be filtered out, and the filtered options will be automatically listed in front and displayed in bold, which is very easy to read.
Chapters:
0:00 Excel pivot table slicer greyed out
0:14 Excel insert slicer no connections found
0:43 Excel pivot table add slicer to filter products from different categories
1:25 Excel pivot table slicer add search field
1:58 Excel pivot table clear a filter
2:13 Excel pivot table remove a slicer
2:25 Have the slicer not show items deleted from the data source
Description:
Excel Pivot Table slicer (greyed out, add them to filter and remove)
After inserting a slicer, if the filter is complete, you can delete the slicer, but be careful to clear the filter before deleting. Also, you need to insert it before filter with a slicer, and when you insert a slicer, you will occasionally encounter a situation where the slicer is gray out and unavailable, which is related to the Excel document type.
One. Excel pivot table slicer greyed out
Slicer is a new feature in Excel 2010, so only Excel documents in the new format (i.e. .xlsx) can use it, the old format .xls cann't use, if the slicer is grayed out and not available, check if the document format is .xlsx, if not, you can open it with Excel 2010 or later and save it as .xlsx format.
Two. Excel insert slicer no connections found
1. In the source worksheet, select the "Insert" tab, click "Slicer", open the "Existing Connections" window, and show that No connection found.
2. Switch to pivot table, select one of the cells (such as A5), and click "Slicer" again to open the "Insert Slicer" window.
3. It can be seen that only by inserting the pivot table first, and then inserting the "slicer", the message "No connections found" window will not pop up, because the slicer is used to filter the data in the pivot table.
Three. Excel pivot table add slicer
(1) Filter products from different categories
1. Switch to the pivot table (without inserting the pivot table first), select one of the cells (such as A5), Excel will automatically display the "Analyze" tab, select it, click "Insert Slicer", open the "Insert Slicers" window, check the three fields of "Classification1, Classification2 and Clothes", click "OK", then insert three slicers, and put them side by side in the order of "Classification1, Classification2 and Clothes".
2. Select "Men's Clothing in "Classification1", then the option belonging to "Men's Clothing" will be automatically displayed in "Classification1 and Clothes", and the one that comes first and the color of text does not turn gray belongs to the "Classification1".
(2) Excel pivot table slicer add search field
1. Add another one on top of the previous three slicers. Select the A4 cell of the table again, select the "Analyze" tab, click "Insert Slicer," check "Sales" in the window that has been opened, and click "OK" to insert the "Sales" slicer, side by side with the other three slices.
2. Select "Men's Clothing" in "Classification1", then the three slicers on the right side of "Classification1" are filtered out options of the "Classification1", and then select "T-shirt" in "Classification2", then filter out the "Clothes and Sales" belonging to "T-shirt".
Note: If you have already inserted some slicers and then added new slicers, you may not be able to filter. At this point, you can try to "Clear Filters", and if that doesn't work, delete all slicers and insert them again.
(3) Clear filters and delete slicers
1. Excel pivot table clear a filter
A. Right-click the slicer we want to clear the filter for, for example, "Classification2", and select "Clear Filter from Classification2" in the pop-up menu.
B. Clear the filter of "Classification2", before select "Shirt" for the "Classification2" , and after clearing the filter, it becomes "T-shirt and shirt".
2. Excel pivot table remove a slicer
A. Right-click the slicer we want to delete, such as "Classification2", and select "Remove Classification2"in the pop-up menu.
B. The "Classification2"" slicer is deleted.
Note: It's a good idea to clear the filter before deleting a slicer, otherwise the table will only be left with filtered records.
Four, Have the slicer not show items deleted from the data source
1. Select a slicer, select the "Options" tab, click "Slicer Settings" , open the "Slicer Settings" window, click "Show items deleted from data source" to uncheck first, click "OK", the slicer will not display the items deleted from the data source.
2. Right-click the slicer, select "Slicer Settings" in the pop-up menu, or we can open the "Slicer Settings" window.
Watch video Excel Pivot Table slicer (greyed out, add them to filter and remove) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 12 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 603 once and liked it 0 people.