Search for courses or lessons
Redeem a coupon
Start free trial
Assume you have two PivotTables (Sales and Inventory) which both include the “Product Size” field. You’d like to give your end user the option to filter the PivotTable to only select product of a specific size, but want to keep both tables filtered by the same sizes. How would you do this?
Select a cell in the Sales pivot, add a slicer for Product Size, select it, go to the Slicer Tools tab > Report Connections and link it to both PivotTables
Go to PivotTable Options > Totals & Filters > Report Connections
Select a cell in the Sales pivot, add a slicer for Product Size. Ensuring a cell is selected in the Sales Pivot, go to the PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections and link the PivotTable to the slicer
Assume you created two PivotTables: Sales is in columns A:B and Inventory is in columns D:E, as shown below. You’d like to keep both tables filtered to the same category, so you select E2 and type =B2. What would you expect to happen when you try to commit the formula?
You would receive an error as you’re not permitted to type into a Report Filter cell on the worksheet
The reports would link and stay in sync
You would receive an error as you’re not permitted to link two report filters in this way
Assume you’ve got the Sales PivotTable (on the left) and the Inventory PivotTable (on the right) linked to the Category slicer as shown below. You then decide you only want the slicer linked to the Sales table (on the left). How would you correct this?
Select the Slicer > Slicer Tools > Report Connections > uncheck the box next to the Inventory PivotTable
Select a cell in the Sales PivotTable > PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections > Uncheck the Slicer
Select a cell in the Inventory PivotTable > Right-click the slicer > Unlink from PivotTable
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement