What happened to Pivot Table view in Access 2013?

Anonymous
2013-03-31T17:57:35+00:00

I cannot see this feature in Access 2013...was it really discontinued?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

127 answers

Sort by: Newest
  1. Anonymous
    2014-12-25T02:11:12+00:00

    It's a shame that some important points on both sides have been culled here.

    I apologise to Scott that he found my criticisms of his opinions so offensive he had to complain to a moderator about them. I dispute that I was any less "nice" than he was. He more or less suggested I couldn't read almost from the beginning of our exchange.

    The material point here is that the Pivot Table is fantastic feature that is a perfect component in a database product. It was brought into Access in the 2003 release. For almost ten years, the Access community began to rely on them as an easy and powerful way of summarising data but for some unfathomable reason Microsoft decided to drop the feature in the 2013 release.

    Scott argued that this was because Access was focused as an "end user tool". I disputed this. I argue that Access has always been much more than an end user tool (think: FileMaker Pro on Mac) and I gave a lot of historical evidence for this.

    By this logic, Pivot Tables should be removed from Excel too, as it is more of an End User tool than Access.

    Access still is (despite recent dumbing down), and has always been, both an end user tool and a developer too. Both. It's not binary.

    Was this answer helpful?

    0 comments No comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2014-12-23T21:17:36+00:00

    Thank you

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-12-23T21:11:54+00:00

    Several posts have been deleted from this thread for violations of the Code of Conduct.

    Allow me to refer to the first rule in the Code of Conduct:

    BE NICE!!!

    Opinions will vary, and polite debates are welcome, but this one got out of hand.

    Thanks,

    David

    Was this answer helpful?

    0 comments No comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  5. Anonymous
    2014-12-23T14:20:12+00:00

    Scott, your "you're misquoting me" rhetoric is getting a bit tedious, and also hypocritical.

    You said yourself "Not sure about the world you are in but in Microsoft's world (and mine as well) a Knowledge worker is one who's primary job is not IT related."

    That's what I suggested might not be right, and yes, you made it clear that you did agree with them on that. In fact it's been you main point in this thread.

    Did I say that the Access security model was "very secure"? No, just powerful.

    For someone who claims to be "normally very precise in ... use of the English language" you're not being very precise here either - where, exactly did I "attack MVPs in general"?

    Let me be clear: I am criticising (not attacking) your input here, not MVPs in general.

    I think you do not understand the philosophy behind the product as well as you claim. You have repeatedly stressed that Access has an "end user" focus, and always has, and tried to use the argument of authority to back that up when the evidence clearly shows that the product also has a rich history as a development platform too. It's not either/or, it's both. It always has been, although I accept that since 2003 the product has been dumbed down, which brings us back to the topic in question - why remove Pivot Tables because it's an "end user" tool (your argument, remember) when it's not been removed from Excel (an even more end user focused tool)?

    Was this answer helpful?

    0 comments No comments