Take a look at these:
http://www.contextures.com/xlPivot02.html
http://peltiertech.com/Excel/Pivots/pivottables.htm

Regards,
Ryan---

--
RyGuy


"cware" wrote:

I need to exclude lines of data from a worksheet based on the value of one of
the cells. Can I do that without "showing" the cell in the Pivot Table?