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
    2017-07-16T10:42:01+00:00

    Right. I explainned wrong. What I wanted to say is that you can design an access application that works without Office (using Access Runtime), but if you designed it to use a table or a graphical graph, you need to use Excel and therefore you need Microsoft Office to do so. It has lost a great tool of data exploitation through Access, and has been derived to another tool that forces the user to have Excel to be able to do the same as before. This is sometimes difficult to explain to the end customer of a development.

    Was this answer helpful?

    0 comments No comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-07-16T10:36:11+00:00

    We can design at access application without office (by access runtime), however if you has incorporated any pivot table or pivot graphics in access, you'll need use excel to can exploted it. That's is a big contradition to development.

    Is possible than microsoft look any way to users use Office? Unless i can't understand this change.

    No you can't design an Access app without Office, The runtime only allows you to USE an Access app, not design one.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2017-07-16T09:48:17+00:00

    Anothers problems too. We can design at access application without office (by access runtime), however if you has incorporated any pivot table or pivot graphics in access, you'll need use excel to can exploted it. That's is a big contradition to development.

    Is possible than microsoft look any way to users use Office? Unless i can't understand this change.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2017-06-23T14:19:10+00:00

    As an Acess prof it's very sat pivot tables/chart are lost in Acces 2012/2016! It was a powerfull tool to analyse data. The workaround i n Excel is poor and not functioning! There occurs data loss and connection problems (Acces vs Excel) Replace the pivots and  Access will be embrassed again by many users!

    Was this answer helpful?

    0 comments No comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2015-12-23T12:29:41+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.

    I can only tell you I have seen some proof of it. It is no secret that Microsoft collects a lot of "telemetry" data from users (or tries to). Whenever you install a Microsoft product you are asked if you want to allow Microsoft to collect this data. The data is collected anonymously, but it does give MS some input to how the products are used, what features are used, etc. That data is reviewed and impacts the decisions as to what features to work on, what to drop etc. 

    I can't tell you how or if that data impacted the decision to drop Pivots from Access 2013. I just don't know. But I do know that there are people at MS that do use that data.

    But MS has stepped up asking for Customer feedback. They have uservoice pages for most of the products. So if you want new features, enhancements to existing features, or dropped features returned. Then use your "uservoice". Encourage colleagues, friends, relatives, strangers on the street, etc. to use their "uservoice".

    Was this answer helpful?

    0 comments No comments