View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary L Brown Gary L Brown is offline
external usenet poster
 
Posts: 219
Default Solve Order of a CalculatedField in a Pivot Table

Does anyone know how to get the Solve Order of a CalculatedField in a pivot
table.

I know how to get the Solve Order of a CalculatedItem but can't seem to
get the CalculatedField!!!

An example of getting the Solve Order of a CalculatedItem is...
ActiveSheet.PivotTables(1).PivotFormulas(1).Index

Any help would be appreciated.

Thanks in advance.

Sincerely,
Gary Brown