Forum Discussion
how to have excel run an analysis using slicer and results in another tab without freezing
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 hav...
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.
