Hi,
when dragging in data fields into a pivot table, the default field type
most often comes up as 'count'. I often have to right click over the
field, and change the field setting to sum, and do this individually
for each field. Does someone know if there is a way to change the
default to 'sum' or to quickly convert all the data fields to sum in my
pivot table? This is annoying the hell out of me!
Much appreciated,
Steve.


--
stevehere
------------------------------------------------------------------------
stevehere's Profile: http://www.excelforum.com/member.php...o&userid=23880
View this thread: http://www.excelforum.com/showthread...hreadid=375182