Maybe you're adding rows of data on the worksheet, then sorting the rows
alphabetically. The pivot table may continue to use the cells that you
originally selected, when you first created the pivot table, ignoring
all the additional rows, where the U-Z entries now appear.

To expand the range automatically, you can use a dynamic range, as
described he

http://www.contextures.com/xlPivot01.html

Sandi wrote:
I go in and select my range when I start the wizard. I don't understand how
it can keep dropping when I refresh. What is a dynamic range formula?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html