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?

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?

If you don't mind seeing the errors on screen, but want to prevent them
from printing, you can change the page setup:

Select the sheet
Choose FilePage Setup
On the Sheet tab, under Cell errors as, choose <blank
Click OK

Daniell wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

It work selecting the options Thanks!

"Debra Dalgleish" wrote:

If you don't mind seeing the errors on screen, but want to prevent them
from printing, you can change the page setup:

Select the sheet
Choose FilePage Setup
On the Sheet tab, under Cell errors as, choose <blank
Click OK

Daniell wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html