Excel Slicer Not Updating? Fixes for PivotTables and Tables

How-to basics · Updated November 21, 2026

If an Excel slicer is not updating, first refresh the PivotTable or source data, then check that the slicer is connected to the report you expect. For an Excel table, confirm the new rows are inside the table; for a PivotTable, confirm its source range includes them and refresh it.

How Excel slicers work

A slicer is a visual filter. Clicking one of its buttons filters a connected Excel table or PivotTable, and the associated report should respond immediately. Slicers do not usually change the source data itself. A PivotTable displays a summarized view of its source, so it may need a refresh before it can show newly added or changed records.

A slicer can also be working correctly while appearing not to affect a particular report. A slicer attached to one PivotTable does not automatically control every PivotTable on a sheet. Similarly, a slicer for an Excel table filters that table; it is not a universal filter for unrelated tables or charts. The first useful question is therefore not just whether the button responds, but which object it is meant to filter.

These checks apply to Excel for Microsoft 365 on Windows. In Excel for Mac, the same core ideas apply, though contextual ribbon labels and their placement can differ. Excel for the web supports common table and PivotTable interactions, but some creation and connection options may be easier to find in the desktop app.

Start with a quick diagnosis

Click a slicer button and watch the connected report, not just the slicer itself. If the button becomes selected but the report stays the same, investigate its connections, source, and refresh state. If you cannot select buttons at all, check whether the worksheet or workbook is protected or whether an object is obstructing the slicer.

  • Only new records are missing: refresh the PivotTable and verify the source includes those records.
  • One report changes but another does not: check the slicer’s report connections.
  • Some expected buttons are absent: inspect the source field values, filters, and slicer settings.
  • Buttons are disabled or the slicer is unresponsive: check protection, selection, and whether the slicer is connected to the intended object.
  • The report changes but shows unexpected results: look for other filters, hidden source rows, or blanks and inconsistent values in the field.

If possible, save a copy before changing a complex report. Then test one slicer selection at a time; this makes it easier to identify whether the problem is data, a connection, or another filter.

Refresh the PivotTable and its source

For a PivotTable, select a cell in the report and choose PivotTable Analyze > Refresh. To update multiple connected queries and PivotTables, use Data > Refresh All. A refresh asks Excel to read the source again; it is usually the right first fix after editing source values or adding records. If the source is an external connection, a refresh may also depend on access to that source.

Refreshing cannot add records that are outside the PivotTable’s source range. Select the PivotTable and choose PivotTable Analyze > Change Data Source to inspect or adjust the range. For example, a PivotTable based on A1:D500 will not include a new record entered in row 501 until its source is expanded or changed. After adjusting the range, refresh again.

For a regularly growing dataset, format the source as an Excel table before building the PivotTable. Select the source cells and choose Insert > Table, making sure the header option reflects whether the first row contains column names. Adding records directly below a table usually expands it, but the PivotTable still needs refreshing to display the new data. If records are loaded by Power Query or another connection, refresh the query or connection as well as checking the PivotTable’s source.

Check which reports the slicer controls

A slicer may be connected to fewer reports than you expect. Select the slicer and look for Slicer > Report Connections in the ribbon. In some Excel layouts or versions, the command is called PivotTable Connections. In the dialog, select the PivotTables that should respond, then confirm. The list only offers compatible PivotTables, generally reports that share the same source or PivotTable cache; separate reports built independently may not be connectable just by checking a box.

This is a frequent cause of apparent failure on dashboard sheets. For example, a slicer may filter a sales PivotTable but not a separate chart whose PivotTable was built from a different source. Check the chart’s underlying PivotTable, not only the chart’s appearance. If the reports do not share a compatible source, consider rebuilding them from a common Excel table or Data Model, then create or reconnect the slicer.

For an Excel table slicer, select the table and use Table Design > Insert Slicer to create a slicer for one of its columns. That slicer filters its table. Do not expect the PivotTable Report Connections dialog to turn a table slicer into a control for unrelated PivotTables.

Confirm the slicer field and source values

A slicer can only show values available in its field, subject to the report’s data and filter settings. Check that the source column contains the value you expect and that the text is consistent. Values such as North, north, and North with a trailing space can behave unexpectedly in a dataset; blanks, misspellings, and inconsistent date entries can also make a selection look incomplete. Correct the source data where appropriate, then refresh the PivotTable.

For PivotTables, old items can sometimes remain available after source values have been removed. Right-click the PivotTable, choose PivotTable Options, open the Data tab, and set Number of items to retain per field to None. Refresh afterward. This setting can clear retained old field items, but it will not restore missing current records or repair an incorrect source range.

If an expected slicer button is present but unavailable, the current report state may have no matching records for it. Other filters, including a report filter or another slicer, can narrow the data. Clear other filters temporarily and test again. In the slicer’s settings, the option to hide items with no data can also affect which buttons are displayed; inspect the slicer settings if values seem to disappear.

Make sure a table includes the new rows

Table slicers respond to the rows in the table, not every cell on the worksheet. Click inside the table and inspect its boundary. If the new records sit below or beside the table without being included, the slicer will not offer their values. Extend the table using Table Design > Resize Table, or enter the records directly in the row immediately below the table so Excel can expand it. Then check that the relevant column contains the expected value.

Be careful when pasting data: a pasted block can overwrite table cells, land outside the table, or introduce a different header or value format. After correcting the table range, click a slicer button again. Unlike a PivotTable, a regular Excel table does not require a PivotTable refresh, because its slicer filters the table rows directly.

When a slicer cannot be clicked or looks stuck

If buttons do not respond, check whether the worksheet is protected. Protection can restrict interaction with objects or report controls, depending on how the sheet was protected. If you have permission, review Review > Unprotect Sheet or ask the workbook owner whether the slicer is intended to be interactive. Also check whether a shape or another object is positioned over the slicer; selecting the slicer object and moving it temporarily can help identify an obstruction.

Make sure you are clicking a button rather than the slicer’s border or resize handles. If the workbook is in a restricted viewing state, open it in the Excel desktop app and confirm that editing is enabled. When the slicer object is selected, its contextual ribbon tab should appear; if it does not, click the slicer itself rather than a nearby chart or cell.

Finally, test whether another filter is masking the result. A slicer selection can combine with report filters, table filters, and other slicers. Clear those filters one at a time rather than assuming the selected slicer is broken. In a PivotTable, choosing PivotTable Analyze > Clear > Clear Filters clears PivotTable filters, so use it carefully if you want to preserve the current report view.

Excel for Mac, the web, and shared workbooks

Excel for Mac has slicers and PivotTables, but ribbon tabs and commands can be arranged differently from Windows. Select the slicer or PivotTable first to reveal its contextual controls, then look for the equivalent connection or refresh command. If a feature or dialog is unavailable in the web version, open the workbook in desktop Excel to inspect its full set of PivotTable and slicer options.

In a shared workbook, another user may have changed the source data or filter state. Confirm that edits have synchronized, then refresh the report if its source changed. If the file is read-only or editing is restricted, the slicer may not behave as it does for an editor. Avoid making separate copies and editing both unless you have a plan to reconcile them; that can create competing versions of the report.

Prevent slicer problems in future reports

A few design choices make slicers more reliable as a workbook grows. Keep one clearly structured source table, use a single header row with unique column names, and avoid blank rows inside the dataset. Build related PivotTables from the same source when they need to respond to the same slicer. For regularly imported data, document the refresh sequence so users know whether to refresh a query, the PivotTable, or both.

  • Use consistent values in slicer fields, especially for categories, dates, and identifiers.
  • Use an Excel table as a growing source and verify that new rows are included.
  • Label slicers so users know which reports they control.
  • Test each slicer after adding a new category or changing the source structure.
  • Keep a backup before changing PivotTable sources or reorganizing a shared dashboard.

These steps also help distinguish a true malfunction from expected behavior: a slicer cannot filter records it cannot see, and it cannot control a report to which it is not connected.

Frequently Asked Questions

Why is my Excel slicer not showing new data?
For a PivotTable, refresh it and confirm that its source range includes the new rows. For a table slicer, make sure the new rows are inside the Excel table. A refresh does not fix a source range that stops before the new records.

How do I connect one slicer to multiple PivotTables?
Select the slicer, choose Slicer > Report Connections (or PivotTable Connections in some layouts), and select compatible PivotTables. If a report is not listed, it may use a different source or cache and may need to be rebuilt from a common source.

Why does a slicer filter one PivotTable but not another?
The slicer may not be connected to the second PivotTable, or that PivotTable may not share a compatible source or cache. Check Report Connections and inspect how each report was created.

Why are some slicer buttons missing or greyed out?
The source may not contain those values, another filter may have removed matching records, or the slicer may be set to hide items with no data. Check the source column, clear other filters temporarily, and review the slicer settings.

Do I need to refresh an Excel table slicer?
No PivotTable refresh is required for an ordinary Excel table slicer. It filters rows in the table directly. If new values do not appear, check that the rows and values are actually part of the table.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.