View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Add PivitField to PivotCache

PivotFields are based on what is in the data. If you want to add a
calculated pivotfield, you do that in the pivottable itself.

--
Regards,
Tom Ogilvy


"Simon Shaw" <simonATsimonstoolsDOTcom wrote in message
...
Hi,

Can I programatically add new PivotFields to a PivotCache. Where the
PivotCache is linked to an external database? I would want to then add
PivotItems to the new PivotField.