Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrading to Excel 2007 (2003)

    We are upgrading to Excel 2007. Is there that great a learning curve from 2003? Will my macros still work in 2007? Is there that great a difference between 2003 and 2007? Thanks for any help you can provide. The reason I ask is because I just got an email about "Training on Excel 2007 tool."

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

    Re: Upgrading to Excel 2007 (2003)

    Apart from several new features such as many more rows and columns per sheet and some new functions, the most visible difference is the interface: the menus and toolbars have been replaced with the so-called ribbon.
    Many macros will still run as under Excel 2003, but code that manipulates menus and toolbars will probably fail, and code that manipulates charts may have problems too.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading to Excel 2007 (2003)

    Yes, I would say there is a learning curve.

    Locating where the commands are will take a little getting used too. Some of my old add ins don't work.

    I've had it for about 6 months though and I like very well.

    Good Luck.

  4. #4
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Upgrading to Excel 2007 (2003)

    I concur with Stans, the new interface takes some time. However 2007 has a "menu" function that displays the "old" menu. I found this useful when pushed for time, to quickly find the function I needed.
    I then go back to the "old" menu system, find that function , then see where it is on the new interface. So it does take a little patience. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Paul Coyle
    Approach love and cooking with reckless abandon

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Upgrading to Excel 2007 (2003)

    I have used XL 2007 for almost a year - I like the increase in rows / columns, although usually when I have that much data Excel is only a way-station in the process of loading into Access; a million rows just means slightly fewer steps in importing and reassembling the data in the database. Apparently '07 is much better in using multiple processors than prior versions, so calculation-intensive tasks may be faster (if you have a dual-core or higher machine) than in 2003 - I never ran 2K or '03 on a dual core box, so I can't compare. As noted by others, the big difference is "the Ribbon" - some seem to tolerate it: I absolutely hate it - partially because it is such an absolulutely useless fiddle: I honestly cannot identify a problem that the Ribbon solves, although there are several that it creates. The graphing interface is less intuitive (although that may be familiarity speaking) than before, and the results -although all in soft pastels- are somewhere between downright ugly and hideous. The only improvement I've seen in graphing is that log scales don't have to be integer powers of ten, which solves some problems; that change is long overdue.

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

    Re: Upgrading to Excel 2007 (2003)

    PaulC:

    That "Menu" thing you refer to is NOT a standard part of Excel 2007. You must have installed a third party tool.
    However, the old menu shortcuts still work.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Upgrading to Excel 2007 (2003)

    As an aid to the transition, I found the <img src=/S/free.gif border=0 alt=free width=30 height=15> Excel 2003 to Excel 2007 interactive command reference guide by Microsoft to be very useful.
    Regards
    Don

  8. #8
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Upgrading to Excel 2007 (2003)

    Ah - was not aware of that the old shortcuts work - thank you <img src=/S/clever.gif border=0 alt=clever width=15 height=15>
    Paul Coyle
    Approach love and cooking with reckless abandon

  9. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Upgrading to Excel 2007 (2003)

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

    I think the learning curve is huge. Especially, since I have customized toolbars with many custom-buttons that I use frequently. I currently have both versions (2003 and 2007) on my machine and I always use the older. The newer is awkward to me and I can never seem to find what I'm looking for and I hate not being able to customize it as I did with 2003. I think it's very user-unfriendly.

    But that's just my opinion and I'm fully aware there are gazillions of people who would disagree. And perhaps if 2007 were the ONLY version I had (and was forced to use it regularly), I would learn to like it more. The path of least resistance is to stick with something that I'm familiar with.

    Lastly, I could think of several upgrades and additions that would have improved 2003. But 2007 was not so much an "upgrade" as it was an introduction of a new application. Honestly, I probably haven't given it a fair chance. I just don't like the feel of it and as long as I have 2003, I'll continue to use the older version.

    On the other hand, I love the 2007 versions of Word and Outlook. Go figure!

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading to Excel 2007 (2003)

    Thanks WDWells - this is very helpful.

Posting Permissions

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