Excel Slicer vs Pivot Table: What’s the Difference?

An Excel PivotTable summarizes and reorganizes data; a slicer is a visual control for filtering a table or PivotTable. They are not competing alternatives: a PivotTable can do useful work without a slicer, while a slicer usually makes an existing report easier to explore.

What a PivotTable does

A PivotTable turns a list of records into a summary without requiring you to write formulas for every grouping. For example, a sales list with columns for Date, Region, Product, and Revenue can become a report showing total revenue by region and product. Dragging fields between the Rows, Columns, Values, and Filters areas changes the view.

Excel calculates the aggregation in the Values area, such as Sum, Count, or Average. It can also group dates, display subtotals, and rearrange categories. The source data should have a single header row, consistent column names, and one record per row. Blank rows or mixed data types can lead to missing or unexpected results.

A PivotTable is therefore the summary and layout itself. It can answer questions such as “Which products generated the most revenue?” or “How did monthly sales compare by region?” It does not have to be accompanied by a chart or slicer, and it can be filtered using its built-in field controls.

What a slicer does

A slicer is an on-sheet panel of buttons for filtering data. A slicer for Region might show East, West, North, and South; selecting West filters the connected report to West. Unlike a small drop-down filter, the slicer keeps the available choices visible, shows which items are selected, and lets readers change the filter with a click.

Slicers can filter Excel Tables as well as PivotTables. On a Table, they show or hide matching records; they do not create totals or rearrange the data into a summary. On a PivotTable, they filter the records included in the summary, and the PivotTable recalculates its displayed results. Date fields can also be controlled with a Timeline, a related visual filter designed for choosing date ranges.

In short, a slicer is a control, not a calculation engine or a report layout. Its visible buttons make filtering more discoverable, but the underlying data and connected object determine what the filtered result contains.

How slicers and PivotTables work together

A common report uses both: the PivotTable provides the summarized answer, and one or more slicers let a reader choose the slice of data to examine. Imagine a PivotTable showing monthly revenue by product. A Region slicer lets someone switch between regions, while a Year slicer changes the period. The same PivotTable updates after each selection.

To add a slicer in Excel for Microsoft 365 on Windows, select a cell in the PivotTable, then choose PivotTable Analyze > Insert Slicer. Choose one or more fields and select OK. For a date field, choose PivotTable Analyze > Insert Timeline instead. To add a slicer to an Excel Table, select a cell in the Table and choose Table Design > Insert Slicer.

Once inserted, move or resize the slicer so its choices are readable. Select one button to filter, use the slicer’s clear-filter icon to remove its selection, or hold Ctrl while selecting to choose multiple items on Windows. A slicer can also be configured to show items with no data, which may be useful for consistent layouts but can make choices appear that return no results.

One slicer can control more than one PivotTable when the reports have a compatible source or PivotTable cache. Select the slicer, open the Slicer tab, and choose Report Connections to see eligible PivotTables. If a report is absent from that list, the PivotTables may have been created from different sources or caches. A slicer for an Excel Table is not a general-purpose control for unrelated PivotTables.

Which should you use?

Choose a PivotTable when you need to summarize, group, compare, or rearrange a dataset. Choose a slicer when you want users to filter a Table or PivotTable through clear, visible choices. Use both when the report needs an interactive summary. The right choice depends on the task, not on which feature is newer or more powerful.

Use a PivotTable to total sales by month, count orders by status, or compare categories across regions.
Use a slicer with a Table when readers need to inspect matching records but do not need a pivoted summary.
Use a slicer with a PivotTable when readers need to change a summary’s region, product, salesperson, or other filter quickly.
Use ordinary filters when the workbook is mainly for your own analysis, the worksheet is crowded, or a compact drop-down is enough.

Consider the audience, too. A prepared PivotTable gives a relatively controlled view of the data, while its field list lets a workbook user change the report structure. A slicer makes a set of filtering choices especially obvious, but does not prevent a user from changing other workbook content or accessing data elsewhere in the file.

Important differences and limitations

A slicer does not replace the PivotTable’s field layout. It cannot turn a list of transactions into a grouped report, change Sum to Average, or add a new calculation just by being clicked. Those are PivotTable tasks. Likewise, creating a PivotTable does not automatically give readers a slicer: they can filter using the PivotTable’s field buttons, or you can add a visual control.

Both features depend on the source data being maintained. If new records are added outside the source range, a PivotTable may not include them after refresh. Converting the source list to an Excel Table before building the PivotTable is often helpful because the Table expands as records are added. You still need to refresh a PivotTable to bring in changed or newly added source data; a slicer selection is not a substitute for refresh.

Slicer choices reflect the field values available in the connected object and can be affected by filters elsewhere. A choice that is unavailable or produces an empty result may be confusing if other filters are active. Clear other selections when troubleshooting, and check that the source has the expected values. If one slicer should control several PivotTables, confirm their compatibility through Report Connections rather than assuming any reports on the same sheet can be connected.

Finally, slicers use worksheet space. A report with many fields can become cluttered if every field gets a large button panel. Keep only the most useful controls visible, give them meaningful headings, and consider using a standard filter for less important fields.

A practical example: regional sales report

Suppose a worksheet has one row per order, with columns for Order Date, Region, Salesperson, Product, and Amount. First, create a PivotTable with Product in Rows and Amount in Values, making sure the value calculation is Sum. Add Order Date to Columns and group it by month if a month-by-month comparison is useful. This layout provides a summary that a raw order list does not.

Next, insert a Region slicer and, if readers need to compare particular periods, a Timeline based on Order Date. A manager can select West and a date range to see the relevant product totals. The slicer controls which regional records contribute to the report; the PivotTable still determines how those records are grouped and totaled.

If the workbook also has a second PivotTable showing sales by salesperson, the Region slicer may control both if they share a compatible source or cache. Verify this in Report Connections. If it cannot connect, recreate the PivotTables from a common source where appropriate, or use separate slicers. This distinction matters: two reports can look as though they use the same data while still being based on different PivotTable caches.

Common misconceptions

“A slicer is a kind of PivotTable.” No. It is a separate filtering object that can be attached to a Table or PivotTable.
“A slicer makes a report interactive by itself.” It only filters its connected object. It does not generate summaries, charts, or calculations on its own.
“Selecting a slicer refreshes the source.” No. It filters the current data available to the connected object. Refresh is still needed when source records or values change.
“One slicer always controls every report in a workbook.” No. Multiple PivotTables must be eligible for connection, and a Table slicer does not automatically control unrelated reports.

Frequently Asked Questions

Can I use a slicer without a PivotTable?
Yes. Select a cell in an Excel Table, then choose Table Design > Insert Slicer. The slicer filters the Table’s rows but does not summarize them. If you need grouped totals or cross-tabulated results, use a PivotTable.

Can a PivotTable work without a slicer?
Yes. PivotTables have built-in field filters, including report filters and row or column label filters. A slicer is optional; it provides a more visible, button-based way to apply selected filters.

Why will my slicer not connect to another PivotTable?
The PivotTable may use a different source or cache, so it is not listed under Slicer > Report Connections. Check how both PivotTables were created and whether they share a compatible source. A shared worksheet alone does not guarantee that they can share a slicer.

Does a slicer update when I add new source data?
A slicer filters the data available to its connected Table or PivotTable; it does not replace updating the source or refreshing a PivotTable. If new records are missing, check the source range and refresh the PivotTable. Using an Excel Table as the source can help include appended records when the PivotTable is refreshed.

What is the difference between a slicer and a Timeline?
A slicer filters categorical fields such as Region or Product. A Timeline is a specialized control for date fields, letting users select periods or date ranges visually. Both are optional filters for PivotTables, but a Timeline is intended for dates.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.