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

127 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-09-22T11:23:30+00:00

    Good for you Wayne, but the whole point of a PivotTable is its dynamic nature.

    In Access 2003, 2007 and 2010 you could build a query (like a star schema to feed Analysis Services) and then base a form on it. It only takes a few minutes to do. Then, any user who knows anything about pivot tables can query the data in many ways without any coding whatsoever.

    Why take out a perfectly good feature like that?

    Algis Kuliukas

    MCP 3343

    ******@kuliukas.com

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-09-22T12:11:18+00:00

    Why take out a perfectly good feature like that?

    Simple, ....

    $$$ MONEY*$$$*

    It is a return to the "bad-old days" when different "versions", aka "price-points", of the Office applications had different feature subsets,  ie "standard" vs "Professional" versions (see Visio!)

    The bean-counters in accounting and marketing got together and figured out that they could "force" users to pay more to get the feature back in the only expensive package it is now offered.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-09-22T12:21:48+00:00

    Hey Rohn007 thanks for commenting.

    So, which version of Access supports PivotTables?

    Have I missed something?

    Algis Kuliukas

    MCP 3343

    ******@kuliukas.com

    Was this answer helpful?

    0 comments
  4. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2014-09-23T02:05:03+00:00

    His comment is off the mark. There is no A2013 version that supports pivot tables.

    If I read the tea leaves correctly MSFT realized it would be too much work to maintain the Access version of Pivot*, while they had a perfectly suitable tool over on the Excel side, with is also much better aligned with the message that Excel is for data analysis. There is a cost associated with "keeping what we have", and that cost was deemed too high.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-09-23T02:31:59+00:00

    Hi Tom

    Thanks for the clarification.

    I can see why that might be the justification for dumbing down Access but it must still be by far the biggest low-mid range PC database out there. How many Access databases are there? Many millions, I suspect. Is that  a drain on resources, or a massive profit opportunity?

    In my humble opinion, Microsoft should have been investing heavily in Access since 2003, not pulling the plug on it.

    Algis Kuliukas

    MCP 3343

    ******@Kuliukas.com

    Was this answer helpful?

    0 comments