Pivot Table #DIV/0! Error

G

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I remove #DIV/0! in a pivot table calculation field ? 2
#DIV/0! in a Pivot Table 1
Pivot Table Calculated Field - Sum/count 1
Pivot Table Calculated field error 1
REALLY NEED HELP ON THIS ONE. 5
#DIV/0! Help! 3
#div/0 error 2
Pivot Table ... DIV/0 ... Error 1

Top