Slicers

Resolved · High Priority · Version 2010

Wed 24 Jan 2018, 15:38 Delegate Nicki said...

Nicki has attended:
Excel Dashboards for Business Intelligence course

Slicers

Good Afternoon
I have two data sheets and have created pivot tables from these. I want to have only one slicer for the date field (month) but cannot link into the pivots from both sets of data. I have tried creating two tables on one sheet but cannot created a relationship between these two!
Is this even possible using Excel 2010 and no powerpivot add in?

many thanks

Wed 24 Jan 2018, 22:09 Trainer Jens said...

RE: Slicers

Hi Nicki,

Thank you for the forum question.

Slicers can filter any number of PivotTables but only if the PivotTables are created from the same source.

If your two tables are related data you can create relationships from MS Query from Get External Data from Other Sources on the Data tab.

You can also merge the two tables by using Power Query which are a free add-in you can download from Microsoft's website.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 25 Jan 2018, 07:32 Delegate Nicki said...

RE: Slicers

Thanks Jens. Our work systems dont allow downloads, so is there a way to do either of these with Excel 2010 and no add-ons?

Thu 25 Jan 2018, 08:52 Trainer Jens said...

RE: Slicers

Hi Nicki,

Yes you can create relationships from MS Query from Get External Data from Other Sources on the Data tab, but only if the tables are related tables (One to Many or One to One relationship).

If the tables are related you can also use a Vlookup to merge the two tables. One column in one of the tables must be related to one column in the second table. At least one of the related columns must only content unique values (the primary key).

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips