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
    2015-12-23T04:45:44+00:00

    When did Access users get an opportunity to voice anything like that? One assumes great features are not going to be removed.

    We didn't. MS always makes it's own decisions. MS claims to listen to users, but it is hard to see proof of that.

    In the past, one could make that assumption. Features were added, and only very rarely removed, usually only after being replaced by an improved version. Starting with 2007 MS has been making unilateral decisions to remove major features, things like:

    • dropping the menu for the ribbon 2007,
    • making retail license good for only one machine at a time, 2013
    • totally eliminating MSI (customizable) installations, 2016
    • playing musical chairs with where PivotTables are located
    • adding restriction to 2016 that now forces users to uninstall ALL older versions of Office!

    IN THEORY, MS listens to input from users during the Beta tests (MS calls them "Previews") right before releasing the product to the public. The problem with that is that it is too late. At that point, MS will only fix major defects.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-12-23T03:48:06+00:00

    When did Access users get an opportunity to voice anything like that? One assumes great features are not going to be removed.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-12-22T18:30:10+00:00

    Maybe I should have been more clear:

    * Because a superior version exists in another MSFT tool (Excel) and maintaining both seems wasteful

    * Because even maintaining a feature throughout the versions requires manpower which we like to pour into the web features

    * Because data from the Customer Experience program tells us few people use it.

    There are several other features cut from A2013 that fall in this category. I understand you don't like it, but there is a rationale, and there is a path forward.

    The Excel pivot table is NOT superior to Access.  They do not operate the same way.  Access HAD the ability to filter data on multiple levels. That is what made it so powerful.   Crossing between systems is inefficient.  

    Disappointed that neither MS or its MVP's understand this.  

    Maybe I should be more clear:   Has Microsoft or its 'MVPs' actually used Access pivot tables?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-12-11T22:20:08+00:00

    I have heard rumors that Microsoft was worried that MS Access was too good, and would compete with a new Business Intelligence tool they are introducing.  The least they can do for developers is to offer the pivot table functionality as an add-in. 

    The reason I heard was that they did not see any need to duplicate the feature in both Access and Excel, so they stripped it out of Access to "save money on development".  Sounds like a lame excuse to me, but there it is.  They also removed PowerPivot from consumer licenses because the BI group decided it is a "business feature". <sigh>

    You can now send the feed back to the "UserVoice.com" sites. It appears that MS really is reviewing and acting on some (a very few) of the suggestions made on this site.

    Here is the specific link you are looking for:

    MS Suggestion box sites at "uservoice.com" Wiki

    If you have an (other) feature suggestions to make for various MS products, here is a longer collection of MS uservoice.com sites:

    **http://answers.microsoft.com/en-us/windows/wiki/windows\_10-desktop/ms-suggestion-box-sites-at-uservoicecom/7397119c-6d48-49e6-8d94-7bd0a50d214f?tm=1447217971960******





    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2015-12-11T21:48:54+00:00

    I am an accountant and a system manager, and I have used MS Access for years as an office automation, report writing, and application development tool.  I depend on it and I use it every day to query and report from large business system databases.  The Pivot Table/Pivot chart functionality was one of the best and most useful enhancements ever made to Access, and I have created several applications that use it as a central feature.  Now I feel like Microsoft has pulled the rug out from under me as a developer.  Excel doesn't handle large number of records like Access, and my application is in Access, not Excel.

    It blows my mind that Microsoft would pull this important functionality out of the app and take a giant step backward.    New releases are supposed to mean enhancements, not degradations. 

    I have heard rumors that Microsoft was worried that MS Access was too good, and would compete with a new Business Intelligence tool they are introducing.  The least they can do for developers is to offer the pivot table functionality as an add-in. 

    Please confirm for me what the reason was for pulling this important functionality, and please share this feedback with the Access development team. RESTORE PIVOT TABLE FUNCTIONALITY TO ACCESS!

    You would have more feedback but where do I send it?  Now I am forced to stay on Access 2010 until we can convince you that pulling pivot table functionality was a mistake.

    Was this answer helpful?

    0 comments No comments