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?
|