What happened to Pivot Table view in Access 2013?

I just got Access 2013 last week and not this makes Access nothing more than a large scale database.  I did not want to make reports because I wanted to make pivot tables and Pivot graphs on the fly.

Now I have to make like 30 reports for each reiteration of a PT graph I had done in the past.

Cannot believe MS would do something this foolish.

I couldn't agree more. I just upgraded as well.

This is extremely frustrating, and in my opinion, a very poor choice.

I used this feature almost daily to review stats in a more real-time way. I did read some other options for utilizing Excel and connecting to Access as a source, but for me (a less technical user) that's way too complicated. 

This move makes Access less relevant as a database/query tool.

Thanks for your response Scott. Hopefully MS will reconsider. 

On the meantime, any info you have on learning to use the Shell command that can connect Excel workbooks with access would be greatly appreciated. 

First I would suggest starting a new thread on this as there are others who may be able to offer suggestions. 

Second, I agree that you don't need the Shell command. Instead I would store the path to the workbook either as a Constant in code or maybe a field in a table. Then use Application.FollowHyperlink to launch it. Within your Excel sheet create a Connection (Data tab) to the table or query where you have your data. Set the connection to place the data on a separate sheet. Then use that sheet as the source for your pivot. When you open the workbook you will be prompted to Refresh the data.

Thanks for your response Scott. Hopefully MS will reconsider. 

On the meantime, any info you have on learning to use the Shell command that can connect Excel workbooks with access would be greatly appreciated. 

I hope you don't mind me chipping in here, as I have just been doing some work on this.

You don't need the shell command to link to open an Excel workbook. The easiest way is to simply embed a hyperlink to the file in a form.

The difficulty I have found is in creating a Pivot Table in Excel with an Access database as a source that is still open, which is usually the case if you want to drive the functionality from your database. You have to export the data from Access first, in my experience.

So, one possible workaround to this problem is as follows.

1. Create a new Access Database, (called e.g. "PivotSource.accdb") and import into it the table(s) in your live database you want to use to create the Pivot table.
2. In your "live" database, create a couple of queries (using the "IN" SQL keyword to open a table in another database file) that deletes the old and then copies the latest "live" data into it. Create a command button (Caption: "Refresh Pivot Data"?) to run these with an embedded macro that does a Delete query, followed by an Append query if you don't want to write any VBA/SQL.
3. Create an Excel workbook with a pivot table with the "PivoutSource.accdb" as a data source. Save the file in a convenient location.
4. Create a hyperlink to the Excel workbook.

As Scott rightly said, this is not difficult.

Thanks for your response Scott. Hopefully MS will reconsider. 

On the meantime, any info you have on learning to use the Shell command that can connect Excel workbooks with access would be greatly appreciated.