View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
jigsaw jigsaw is offline
external usenet poster
 
Posts: 2
Default Create set based on column items feature in Pivot Tables 2010

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

:(

On Nov 23, 10:16*am, jigsaw 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