I tried the solution you provided on the site...it didn't work. The
information directly addressed the problem...that is what I'm trying to
fix.....it just didn't fix it. I didn't try the visual basic solution as I
am not familier with VB. Any other suggestions?

"Peo Sjoblom" wrote:

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



--

Regards,

Peo Sjoblom



"excel_user123456" wrote in
message ...
I am using Excel 2003. I have a worksheet full of data and built a pivot
table on another sheet (within the existing datasheet). Nothing too
complicated.

I updated my data by pasting new data over the top of the old data and
updated my pivot table.

The problem is that in the pivot table one of the fields still allows me
to
select on data that no longer exists in the data. More specifically, I
have
a column in the base data entitled "Vendors" and have approximately 20
different vendors that appear throughout the data. When I update my pivot
table, in the vendor selection list I have the current 20 vendors....fine.
However, I also have approximately 5 other vendors that were listed in old
data that are not in the current data.

How do I prevent the old data from appearing in the updated pivot table?