Jun 02, 2016 Excel slicer not working in two pivot tables. Microsoft Office. Which are filtered with a slicer. They still work, but if I re-do the steps, it is not possible anymore. Seems to me related to Excel, rather than Project Online. In Power BI it works perfectly.
Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click
Video: Add Slicers to Filter Pivot Table Data
In this video you can see the steps for adding a slicer to a pivot table in Excel 2010, and then using slicers to filter the data. The written instructions are below the video.
Add Slicers to Filter Pivot Table Data
Introduced in Excel 2010, Slicers are a powerful new way to filter pivot table data.
It's easy to add a Slicer:
Video: Filter Multiple Pivot Tables With One Slicer
In this video, you'll see the steps for connecting multiple pivot tables to a slicer, so they can all be filtered with a single click.
Video: Change All Pivot Charts With One Filter
This video shows how you can use a single Report Filter, connected to a slicer, to update multiple pivot charts. The slicers are stored on a different worksheet, so they don't take up room on your Excel dashboard sheet.
Watch this video to see how to set up the pivot tables and the pivot charts, and connect them to the slicer.
Video: Problem With Drill to Detail and Slicers
Slicers, combined with a pivot table's Drill to Detail feature, can produce unexpected results. See the problem in this video.
Video: Problems With Adding Slicers
Update older Excel files, if you want to use Slicers with the pivot tables in those files. Occasionally, there is a problem updating a pivot table, so you can try to repair it, by following the steps in this video.
Written instructions are below the video.
Problems With Adding Slicers
Usually it's easy to add a Slicer to a pivot table, but for files that were created in older versions of Excel, you might need to update the file before adding Slicers.
To use Slicers in a pivot table created in Excel 2003, follow these steps to update the file to a newer format:
After you update the file, the title bar will still show [Compatibility Mode] after the file name. Follow these steps to complete the update:
Update Files Won't Allow Slicers
After following these steps, most files will allow you to add Slicers to the pivot tables. However, the occasional file might not show an enabled Slicer button, even after updating.
If you encounter that problem, there is probably some corruption in the old pivot table,
To try to repair the pivot table:
The final step is to save the file back into the newer format.
Then, select a cell in the pivot table, and if the repair was successful, you will be able to insert a Slicer.
Download the Sample File
If you need sample data to test with these pivot table Slicer videos, click here to download a zipped sample file with Region Sales data. It also has a pivot table with two Slicers set up. The zipped file is in xlsx format, and does not contain macros.
More Tutorials
Hi,has someone dealt with this before and knows of a solution?my Excel version is Windows, Office 2010.i designed a template report using slicers on local pivot tables (i.e. Not a hypercube pivot table etc).clicking on the the different slicer buttons works fine for me.however, my colleague who uses a Mac and Office 2016 says that the slicer buttons don't work for her.
Pressing the buttons does not result in any changes.another colleague on Windows says it works fine (in her case, I don't know which office version she has)is this a true incompatibilty between Windows and Mac, or just between those office versions?any way to solve this?any help would be greatly appreciated.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |