Challenge 3: Table Auto-Expansion vs. PivotTable Refresh — Solution Walkthrough

The colleague is INCORRECT — or more precisely, half right in a way
that leads to the wrong conclusion.

What's actually true:

The Excel Table itself did auto-expand correctly the moment the 200
new rows were added — that part of the colleague's reasoning,
covered back in Chapter 7, is accurate. The Table's own filters,
formulas using structured references, and formatting would all
already reflect the new rows automatically, with no manual step
needed for the Table itself.

What's still missing:

A PivotTable is a separate, cached SNAPSHOT of whatever its source
looked like the last time it was built or refreshed — it does not
watch its source data live. Even though the Table underneath it now
genuinely contains the 200 new rows, the PivotTable's own displayed
numbers still reflect only the OLD data, from before those rows were
added, until someone explicitly right-clicks the PivotTable and
chooses Refresh (or uses Data > Refresh All).

The step still needed: right-click anywhere inside the PivotTable
and select Refresh.

Explanation:

This is exactly the distinction this chapter's own tip box draws:
Table auto-expansion and PivotTable refreshing are two separate
mechanisms that happen to often get mentally lumped together because
they both relate to "the data grew." The Table growing automatically
does NOT cause the PivotTable built from it to update automatically
— the PivotTable still needs its own explicit refresh step every
single time the underlying data changes, regardless of whether that
underlying data lives in a plain range or a self-expanding Table.