View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Daniell Daniell is offline
external usenet poster
 
Posts: 15
Default Pivot Table #DIV/0! Error

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