View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan the man stan dan the man stan is offline
external usenet poster
 
Posts: 1
Default How do you keep source values on a Pivot Table w/o formulas?

I want to use a set of values as the data field in a Pivot table. Excel wants
to use a formula like COUNT in the data field. How do I prevent this? How do
I get Excel to use my values in the data field?