Hi,

I've a Excel (vsto) COM AddIn and use Pivot Table extensively for reporting and in some cases we disable EnableDataValueEditing to allow edits in the data area. We use PivotTable.GetPivotData quite often for finding the cell address of an intersection in the Pivot Table to explicitly do some styling or overwrite the summary value of an intersection because we have some custom summary functions that is not supported by Pivot Table.

The performance of PivotTable.GetPivotData seems to be around 6000 lookups in a sec.

Are there better ways (performance wise) to look up cell address of a pivot table intersection?

Thanks.

B.M