I have a pivot table created in 2010 that I would like to use the
'create sets' feature in. However it is not enabled.

The three 'sets' features are disabled as are the OLAP tools / What if
analysis options on the Pivot Table options ribbon.

What am i missing???

Cheers
Julie

Okay, found the problem - for 2010 the sets are only allowable for
OLAP based Pivot Tables.



On Nov 23, 10:16*am, jigsaw <jul...@consultant.com> wrote:
> I have a pivot table created in 2010 that I would like to use the
> 'create sets' feature in. *However it is not enabled.
>
> The three 'sets' features are disabled as are the OLAP tools / What if
> analysis options on the Pivot Table options ribbon.
>
> What am i missing???
>
> Cheers
> Julie