View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RussellT RussellT is offline
external usenet poster
 
Posts: 38
Default Pivot Table Error

Thanks in advance.

I create PivotTables where one of the datafields is a Calced Field.
Sometimes the resulting calced field return #DIV/0! because of this the
resulting tables in the PivotTable display #DIV/0! also instead of the
totals. Any way around this problem?