thanks debra. i actually was able to figure this one out . But thanks for
responding!

"Debra Dalgleish" wrote:

You can hide the errors:

Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to 'For error values, show'
Leave the text box empty
Click OK

jerry wrote:
I am getting a div/o error, when i insert a calculation into a pivot table.
How can i leave blank instead of getting the Div/0 error

thanks
jerry




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html