Hi
Try dragging Region out of the PT, then Refreshing the table with the
red exclamation, then drag Region back to the PT again.
If the PT had values against the States originally (whilst they were
wrongly allocated to the wrong region, even though there is no data
there now, the PT does retain unused values.

--
Regards

Roger Govier


"dicox" wrote in message
...
I have a pivot table with 2 regions in it. Eastern region has FL, VA;
Western
region CA. For whatever reason, the pivot table shows both Eastern and
Western region with all 3 states FL, VA and CA, with empty values for
the
states that do not belong to the region. How can I get rid of the
states that
do not belong to the region?