PDA

View Full Version : Is Excel 2007 back compatible to 100%?



chamster
11-28-2007, 04:31 AM
I wonder if there's any feature/command/miscellanous that works in Excel 2003 but not in Excel 2007. Is there anything at all? (For instance, it could be something that is called differently or has a different, improved, syntax.)

Bob Phillips
11-28-2007, 05:30 AM
There is no FileSearch in Excel 2007 as a starter.

chamster
11-28-2007, 06:03 AM
That's good to know. What more have you got? I assumed there was a list somewhere (at MS?) but i've been unsuccessful locating it. Hints are welcome.

rory
11-28-2007, 06:15 AM
The chart model has changed in 2007 - although most chart code should work as it was, I have read some reports of oddities such as lines needing to be in a different order (and of course you can't record a macro in 2007 to figure it out, because the recorder doesn't work with charts anymore).

jwilder1
11-28-2007, 06:35 AM
Don't know about 2007 vs 2003, using 2003 vs 97, recording a macro using the text import wizard wasn't compatible. ( Origin:=437 vs Origin:= xlWindows and no TrailingMinusNumbers:=True )

chamster
11-28-2007, 06:41 AM
The chart model has changed in 2007 - although most chart code should work as it was, I have read some reports of oddities such as lines needing to be in a different order (and of course you can't record a macro in 2007 to figure it out, because the recorder doesn't work with charts anymore).

Thanks to everybody in general and to you Rory especially. I owe you big time for the last few months. You've been a rock and a seivior. This is probably the last thread i'll post in a very long time, if ever, since i'll be working with APL now. Of that occasion, i'd like to say bye and renew my offer - if you're ever in Western Sweden, let me know! :friends:

Until then, keep on hinting what's different between 2003 and 2007!

rory
11-28-2007, 06:43 AM
What's APL - Assembler? :)
Thanks for the offer - I'll keep it in mind!

chamster
11-28-2007, 06:45 AM
APL is a programming language.

...or rather...

APL stand for "A Programming Langauge".

It's an ancient language from the time when Cobol programmers still had hair instead of wrincles. Super strange syntax and a set of own characters, not to be found anywhere else except math and logics.

Bob Phillips
11-28-2007, 06:45 AM
Here is a list of changes http://office.microsoft.com/en-us/help/HA100738731033.aspx, although it is from MS so it doesn't cover what they have buggered up. I know that F4 is nowhere near as useful as it was for instance, and whilst I am not a charting person, it seems that charts are even harder to use in 2007 if you want to tweak them.

chamster
11-28-2007, 06:51 AM
Here is a list of changes http://office.microsoft.com/en-us/help/HA100738731033.aspx, although it is from MS so it doesn't cover what they have buggered up. I know that F4 is nowhere near as useful as it was for instance, and whilst I am not a charting person, it seems that charts are even harder to use in 2007 if you want to tweak them.

It seems to me that most of the changes MS has done to Excel are regarded as lousy and unneccessary. Are we getting inflexible and used to the "ol' good ways" or is it really so bad? I've been hearing similar things about other products and the comments have came from a wide spectrum of skill levels. Is 2007 a mistake?

rory
11-28-2007, 07:00 AM
I think there are some good ideas in there, some bad, and some stuff that hasn't changed that probably should have, and it's only natural that a complete interface overhaul is going to annoy people who knew exactly where everything was and how it worked - they (we) tend to be the most vocal too... :)
I tend to think of it more as MS NewOffice v1.0 rather than Office2007 (or Office12) and we all know what version 1 is usually like. By Office 14 I like to think a lot of stuff will have been ironed out.
Just my tuppenceworth.