No Pivot Table or Pivot Chart options? (1 Viewer)

stoolpigeon · Apr 27, 2013

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 · Apr 27, 2013

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

Pat Hartman · Apr 28, 2013

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

Redpab · Nov 2, 2013

stoolpigeon said:
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 · Nov 3, 2013

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

Redpab · Nov 3, 2013

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

JHB · Nov 3, 2013

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".

No Pivot Table or Pivot Chart options? (1 Viewer)

stoolpigeon

Registered User.

stoolpigeon

Registered User.

Pat Hartman

Super Moderator

Redpab

New member

JHB

Have been here a while

Attachments

Redpab

New member

JHB

Have been here a while

Attachments

Similar threads

Users who are viewing this thread