One slicer moves every pivot that uses its range, and only those

A slicer filters pivot tables and charts whose data range is the range on the slicer. It does not store a list of pivot names you tick one by one. Two pivots built on A1:B4 both move when you filter that slicer. A third pivot built on a pasted copy stays put. The slicer looks like it “only controls one pivot.” It controls every object connected to that rectangle, and none of the others. Selecting charts and grouping them does not create that connection.

A slicer pointed at a copy while the pivot reads the original is slicer not on pivot. A pivot that ignores a new row under its range is pivot not refreshing. Keep the Google Sheets UI in English. Sheet Error is an independent formula-error library, not a Google product.

Recreate it on a blank sheet

1. Open a blank spreadsheet. In A1 type store, B1 qty. A2 East, B2 10. A3 West, B3 4. A4 East, B4 6. East’s total is 16. West’s is 4.

Two pivots on the same range. Select A1:B4. Insert → Pivot table. Put it on the same sheet starting at D1. Rows: store. Values: qty summarized by SUM. The editor range is A1:B4. East 16, West 4. Select A1:B4 again. Insert → Pivot table, starting at D8. The same rows and values. The second editor range is also A1:B4. Both pivots show East 16 and West 4.

One slicer on that range. Click a blank cell. Insert → Slicer. Data range A1:B4. Column store. Filter to West only. Both pivots show West 4 and drop East. One slicer, two pivots, no extra “connect” step. Clear the slicer so both stores return. That pair is the control.

A third pivot on a copy does not move. Copy A1:B4 to F1. Select F1:G4. Insert → Pivot table starting at H1. Rows store, values qty. This pivot also shows East 16 and West 4, and its range is F1:G4. Filter the slicer to West again. The pivots at D1 and D8 show West only. The pivot at H1 still shows East 16 and West 4. Leave the slicer on West. Leave H1 showing both stores.

Grouping charts is not a connection. If you also inserted a chart on F1:G4, select that chart and the slicer and use the arrange or group command if your menu offers it. The H1 pivot does not start following the slicer. Ungroup. The ranges are still different. Grouping moves objects on the canvas. It does not edit the pivot’s data range.

A filter view on A1:B4 is not a slicer. See filter view vs filter.

What is actually wrong

• The slicer stores a range and a column. Each pivot stores a range. Equality of those ranges is the link. D1 and D8 match the slicer. H1 matches the copy. Three pivots, one connection rule, two behaviors.
• There is nothing to set called “apply this slicer to pivot 2” in the slicer panel. Adding that second pivot on A1:B4 was the connection. A pivot on another tab that uses Sheet1!A1:B4 is the same range and will follow. A pivot that uses another tab’s copy will not.
• A chart built on A1:B4 follows this slicer too. A chart built on F1:G4 follows a slicer whose range is F1:G4. “The chart moved and the pivot did not” means you are looking at two ranges. The chart page for a disconnected slicer is slicer not on pivot.
• The slicer does not widen a pivot. Row 5 typed under the table is outside A1:B4 until you extend every pivot and the slicer. That stale total is pivot not refreshing.

This is not GETPIVOTDATA. That function reads the pivot you point at. See GETPIVOTDATA.

Fix

Leave the West filter on, with H1 still showing both stores, until you have compared the ranges.

Point the quiet pivot at the slicer’s range. Open the H1 pivot editor. Set the data range to A1:B4. Filter the slicer to West. H1 drops East, together with D1 and D8. Select all stores. All three pivots show East 16 and West 4.

When one pivot must stay independent, keep it on F1:G4 and give it a second slicer whose range is F1:G4. Do not group it with the first slicer and expect a shared filter. Two rectangles, two slicers.

Do not rebuild the second report with SUMIF to imitate a slicer the range already provides.

If one pivot moves and another does not, read both data-range boxes. The quiet one is a different rectangle. If both boxes match and a new row is missing from both, the range ends above that row. Grouping the chart objects will not fix either case.