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