Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Upgraded to Excel 2007-Can't find commands (Excel 2007)

    Hi,
    I'm feeling inept since I changed over from Excel 2003 to Excel 2007... I can't for the life of me find how to change the data source inside an existing pivot table. I did this a gazillion times in the old Excel and I can't find where to do it in Excel 2007. Also, I'd love to have a "pivot table" menu like I did with the old Excel, and I had it on the left side of my worksheet going up and down. Likewise I had the VBA menu on my right side going up & down... is this NOT an option in '07. And on a final note, I've minimized my ribbon and have slowly found the shortcuts/commands I need for my customized tool bar, but it doesn't stack them like the OLD Excel did... in other words, I have too many commands on my customized tool bar, so now it makes me click on the arrow on the right hand side of the screen to show the items that didn't fit on the screen. It used to be able to be displayed on two bars across the screen if you had a lot of them. Any help is always appreciated!
    Thanks!
    Lana

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Upgraded to Excel 2007-Can't find commands (Excel 2007)

    If you click anywhere in a pivot table, the Ribbon will have two new parts: Options and Design.
    The Options ribbon contains useful buttons such as Move Pivot Table and Change Data Source.

    An interactive guide that teaches you where Excel 2003 commands are located on the ribbon: Interactive: Excel 2003 to Excel 2007 command reference guide.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Upgraded to Excel 2007-Can't find commands (Excel 2007)

    Thanks for the link Hans... I've already used it and found a few other items I was looking for. One last question... will 2007 let me have more than ONE bar of commands, or do I have to keep clicking the arrow to see the 2nd bar commands.
    Thanks!
    Lana

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Upgraded to Excel 2007-Can't find commands (Excel 2007)

    I don't have office 2007 myself, so I can't check this myself, but I think you're limited to the single Quick Access Toolbar.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgraded to Excel 2007-Can't find commands (Excel 2007)

    A very useful tool for anyone working with Office 2007 is this one:

    http://www.officelabs.com/projects/searchc...es/default.aspx
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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