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. ScottGem 68,840 Reputation points Volunteer Moderator
    2014-12-18T21:29:03+00:00

    You can see that we, the Access development community are disappointed and getting very nervous.  There appears to be no future for Access and that makes me very nervous.

    I had to comment on this. Mark, Access is not and has never been designed for the developer community. It is being targeted towards the Knowledge Worker. That Access has proven to be a tool for developers has knocked MS for a loop. They want developers to use Visual Studio.

    Also, a new version doesn't necessarily mean improved in every feature. The fact is that Pivot tables are not easily understood by the knowledge worker. And while developers have made great use of them to make attractive apps for end users, developers are not the target market. So, resources have been diverted to other enhancements and some features have been deprecated. 

    It is not that difficult, to automate opening an Excel sheet from Access to use Pivots there.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-12-18T20:28:11+00:00

    "maintaining both seems wasteful"

    similar to now having to develop/maintain our applications in MS Access with the related pivot tables/forms in MS Excel? MS just moved the burden to the users instead of the Microsoft developers, I guess. very disappointing!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-09-25T09:04:55+00:00

    Please could someone responsible for this from Microsoft tell us why this was done?

    Algis Kuliukas

    MCP3343

    *** Email address is removed for privacy ***

    MS will NEVER officially reply to this question.  MS "officials" reply to question in this forum extremely rarely.

    Unofficially, the answer is simple. It is a way of extracting more money from customers.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2014-09-25T08:38:45+00:00

    Sorry, I misspoke.

    I was specifically thinking of Excel 2013 which now has had "BI" (Business Intelligence) features limited to the Pro bundle.

    This article is slightly off topic to your question, it describes how "PowerPivot" has been limited in Excel 2013.

    Trouble shoot - Version compatibility between PowerPivot Data Models in Excel 2010 and Excel 2013

    **http://office.microsoft.com/en-us/excel-help/version-compatibility-between-powerpivot-data-models-in-excel-2010-and-excel-2013-HA103929426.aspx******

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2014-09-25T00:29:55+00:00

    Please could someone responsible for this from Microsoft tell us why this was done?

    Algis Kuliukas

    MCP3343

    ******@kuliukas.com

    Was this answer helpful?

    0 comments No comments