Pivot Table #DIV/0! Error

D

Daniell

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

Debra Dalgleish

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 File>Page Setup
 
R

Roger Govier

Hi Daniell

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

Daniell

It work selecting the options Thanks!

Debra Dalgleish said:
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 File>Page Setup
Click to expand...
 
Top