View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniell Daniell is offline
external usenet poster
 
Posts: 15
Default Pivot Table #DIV/0! Error

I created a Pivot table and set all fields to be numeric. After that I went
to the Field Settings and selected AVERAGE and recieve the error #DIV/0!. Is
there anyway to get around this printing?