View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lackawanna52 Lackawanna52 is offline
external usenet poster
 
Posts: 6
Default Pivot Table, Subtotal, CalculatedItem

I have a pivot table, with a calculated item. When i try and subtotal on the
field which includes the calculated item i receive the following error
"Unable to set the Subtotals property of the PivotField class". If i don't
create the calculated item if works fine. What have i missed?