hey - Thanks Shane

ShaneDevenshire wrote:
Hi,

This happens because at least one cell in the data source field contains
either text or is blank. This is Excel's default behaviour. If all the
cells are numeric the default calcualtion is SUM.
You can't change this default, but you can always change the calculation
while creating the PT or afterwards. I suppose you could write VBA code to
do the conversion automatically.

Hi there
On a Pivot tabe layout, you have a section for Data, Page, Column & row.
[quoted text clipped - 3 lines]
Thanks very much
Matt

--
Matt Lynn

Message posted via http://www.officekb.com