What happened to Pivot Table view in Access 2013?

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.

...

I think I can safely say that MS is well aware that this move upset a good number of people. Personally, I don't think it will be enough to spur them to invest the resources to restore it. But who knows what the future will bring. 

As a percentage of Microsoft's annual Development spend, what would be a reasonable estimate of what it would cost to restore a feature to a product that had already happily complemented it for over a decade?

0.0001%? - or am I being too generous?

Microsoft has shown contempt to millions of Access Users with this move. Bringing it back would show they listen to their customers - as they did with the re-introduction of the File Tab in Office 2010.

.... Like most people in this forum, I was simply disappointed with the removal of the pivot table feature and wanted to voice my disappointment. 

...  Every message from Microsoft or MVPs in this specific forum has been  either "you don't really need the feature because you have it in Excel" or "Microsoft has a strategy and it does not target you".  

As you can imagine it's a bit frustrating.  ...

I agree 100%.