The Microsoft programmers with Excel and the group who represent the PowerPivot addin got jealous. This is a feature that theoretically belongs in the domain of multidimensional databases (as opposed to relational databases). Remember that Access is fundamentally a Relational database. This could be a move on the part of Microsoft to introduce a more industrial strength version of PowerPivot (which I belive may be currently available). Although Microsoft Access is a very powerful database, the big push in the industry is now with "Big Data", or business intelligence, and unfortunately Microsoft thinks that Access cannot handle multidimensional mega large (> 100M records) data sets. Keeping the pivot table feature in Access would not give the needed limelight to the group who has come up with Power Pivot and the multidimensional software (which, by the way, is MUCH more expensive than Access). Please remember that Microsoft is in business to make money and profits, and removing the pivot table feature was not personal. You can always bring the table or query into Excel and do the pivot table that way. But I understand your desire to have this feature remain in Access.