Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Pivot tables in Excel 2010 convert to 2033?

    We do a lot of pivot tables and love the new features in Excel 2010.
    However, about half the people in my group ares till on 2003 and we do not seem to be able to convert the pivots to 2003.
    Is there a trick to it?

    Thanks,

    itconc

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Itconc,

    The only way you can convert backwards is to forgo the use of any of the new features in 2010. The one sure way to do this that I know is to save your file in 2003 format (i.e. .xls) BEFORE you create the Pivot table that way it won't let you use any of the new features. Perhaps there is another way but that's the only one I can think of.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Hi

    To convert to Excel2033 is way ahead of time.
    The simplest solution is to convert everyone to Excel2010 until then.
    Or use RG's advice.

    zeddy

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I guess you never make typos.

  5. #5
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    We played with this a while and then found that if you use an old 2003 file, delete the data and paste the new data in, the pivot will work fine.
    Thanks for the help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •