No Pivot Table or Pivot Chart options?

[stoolpigeon]

Slightly embarrassed to be asking this question but if I've got a table open and I want to see it in a pivot table, shouldn't it just be a case of selecting View > Pivot Table view? I don't have any option there for pivot table or for pivot chart, have I toggled these off somehow?

 

[stoolpigeon]

I've just read that they've been discontinued with access 2013. Can anyone tell me why?

 

[Pat Hartman]

Apparently, not enough people use it. You'll need to create Excel extracts and let your users create their own.

 

[Redpab]

Slightly embarrassed to be asking this question but if I've got a table open and I want to see it in a pivot table, shouldn't it just be a case of selecting View > Pivot Table view? I don't have any option there for pivot table or for pivot chart, have I toggled these off somehow?[/QUOTE


Hi I am having the same problem with Access 2010. Is it not availble also?

I know this is old but can someone help? Please!!!

 

[JHB]

In 2010 it is still there, (open the table).

 

[Redpab]

Thanks, but that is the problem I don't have those choices to pick from.

 

[JHB]

Ok - then I think you set the form property for "Allow Pivottable View" and "Allow Pivotchart View" to "No".
Open the form in design view, change the 2 properties to "Yes".