Hi,

As an update to this. It seems that this action does work but not on pivot tables that have previously been created. If i create a new table then the action is available.

Even after doing a "refresh all" in Excel the action is not available on PivotTables that have previously been created. I'm going to investigate further but may well end up creating a connect item.

Thanks,

Simon