how to have excel run an analysis using slicer and results in another tab without freezing

Copper Contributor

Hi,

 

I am trying to compose a workbook that has multiple department schedules, separated by department name with different tabs,  I would like to have my boss select the slicers in one tab and have the results populate in another tab without excel slowing down because the amount of data, we have about 3000 employees.  How can I run a multiple data search and link them to one slicer "Filter", using different tabs per department, without using VBA?

2 Replies

@nala2c 

You could use a slicer in conjunction with this feature:

Expand, collapse, or show details in a PivotTable or PivotChart (microsoft.com)

Show value field details

  • In a PivotTable, do one of the following:

    • Right-click a field in the values area of the PivotTable, and then click Show Details.

    • Double-click a field in the values area of the PivotTable.

      The detail data that the value field is based on, is placed on a new worksheet.

Thank you! I will try it, I hope excel does not freeze.