Results 1 to 2 of 2
  1. #1
    moose_25_2500 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    1

    Upgrading Access 2007 to 2016 thru Office 365 Lost Pivot Tables

    Would love to hear your opinions on this. I have a pretty basic Access 2007 data base and I am in the process of upgrading multiple computers and thought it was the right time to move to Office 365. So the 1st computer is done and running office 365.... I just realized the reason why I lost my pivot tables. They were deleted in the 2013 version...thanks Microsoft...I only use these tables for 2 sections of data and is so nice to have them in my database. So question #1 if I go by access 2010 will my pivot tables work properly? is there somewhere where I can test it on 2010 without dropping $200?

    or should I figure out a way to export to excel... I do not know access that well and will have to hire someone to do this?




    I am in a bind since my other computers are ordered and being delivered this week. I would rather use 2010 version if it works so I will have more time to figure this out.

    Thanks

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    If "pivot tables" mean "crosstab queries", as far as I can tell, crosstab queries are available in the 2010 desktop version of Access.
    I don't know if the 2010 ver. of Office 365 version of Access still has crosstab queries.

    You might also read this link:

    If you're looking at OFFICE 365, and you use Microsoft Access, look harder
    https://www.linkedin.com/pulse/20140...ss-look-harder

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Event Handlers for Pivot Tables [Access 2007]
    By anozir in forum Programming
    Replies: 3
    Last Post: 06-25-2013, 01:32 PM
  2. Upgrading from Office XP to Office 2010
    By Mohamed in forum Access
    Replies: 1
    Last Post: 02-20-2012, 11:32 AM
  3. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  4. Replies: 3
    Last Post: 08-31-2010, 12:44 PM
  5. Error after upgrading to Access 2007
    By bmcclellan in forum Queries
    Replies: 9
    Last Post: 03-22-2010, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums