I needed to go into the field properties in the pivot table field, and
then select zero for an automatic fill of balnk pivot table cells.
--
Will C.
------------------------------------------------------------------------
Will C.'s Profile:
http://www.excelforum.com/member.php...o&userid=35051
View this thread:
http://www.excelforum.com/showthread...hreadid=547961