View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Pivot Table #DIV/0! Error

Hi Daniell

From the PT toolbar, select Table Options.
Tick Format Errors and choose what you want to show.

--
Regards

Roger Govier


"Daniell" wrote in message
...
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?