Creating Pivots in Excel 2011 that can be used in Excel 2003 (Windows)

Discussion in 'Mac Apps and Mac App Store' started by Extreme Red, Jun 5, 2012.

Most Liked Posts
  1. Extreme Red, Jun 5, 2012

    Extreme Red macrumors newbie

    Joined:
    May 22, 2008
    #1
    I have created some very basic pivot tables in Excel 2011, when I share these files with Windows user either as xlsx or xls files they can open them and see the table but they can not adjust any of the drop downs.

    Is this a known problem, or is there something that I need to do differently.

    Thank you for any suggestions
     
    share
    + Quote Reply
  2. blevins321, Jun 5, 2012

    blevins321 macrumors 68030

    Joined:
    Dec 24, 2010
    Location:
    Winnipeg, MB
    #2
    Have you tried going the other direction? Creating the tables in Excel 2003 and using them in 201x?
     
    share
    + Quote Reply
  3. Extreme Red, Jun 5, 2012

    Extreme Red thread starter macrumors newbie

    Joined:
    May 22, 2008
    #3
    yes - that seems to work no problem.

    Since I only have a mac and it appears that I can't share pivots that would greatly limit the usability of the pivots.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page