Features removed from 2013?!

[jmhultin]

I finally decided to make the leap into Access (I'm well-versed with Excel, but now I've got some files with well over a million rows). So I get Access 2013, and find that they have removed pivot tables! That was going to be my main tool to summarize my data enough to work with in in Excel.



I thought new versions were to have MORE features, not less. Can I trade in my 2013 for 2010?

Primarily venting, but maybe somebody has some ideas.

[alansidman]

Difficult to find AC2010 but what you can do is create your query in Access, export it to Excel and create your pivot table there. Alternatively, you can open Excel and retrieve the data in an Access query. On the ribbon in Excel, go the the external data tab and select Access and follow the wizard.

[jmhultin]

I guess I just figured it out. Excel 2013 has enhanced pivot table features which allow one to build a pivot table from an Access file.