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.

  1. 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
     
  2. 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?
     
  3. 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 This Page