Excel 2007 vs Excel 2008?

[Ted M H]

I've read about the VBA functions being removed from Excel 2008 and that
covers a big area of difference, but I'm wondering what else is different
between these two versions. Are all the Excel 2007 built-in functions also
available in 2008 or is there a list somewhere that shows which functions are
missing?

Also do charting and pivot tables function the same in 2007 and 2008, or are
there some differences? If the latter, any suggestions as to where I can
find a list of the differences?

I'm really looking to understand functional differences as opposed to user
interface differences.

Any suggestions would be appreciated.

 

[Phillip Jones]

There's is some type of device called a Ribbon (has to do with the items
on the menu bar) in 2007. That some here that have tried both think its
the greatest discovery since swiss cheese! Then again there are other
that just as soon it never have been discovered.

almost all Macros except some Excel and word 4 based Macros don't work
because they were created with VBA.

The best way to find out is set up a time with a PC buddy to let them
open their Windows2007 version and do the same with a Mac buddy and let
them try out the office 2008 version. So you can see for yourself.

My suggestion if you want to be able to work between a PC and Mac
environment at the same time. Don't get within 20 miles of Office2008
you will be disappointed. Get Office2004 or stay with 2004 and update
11.5 version which is supposed to put the XML Converters in 2004 (allow
you to open and save in the XML style.

The next version in 2010,12, 14 or when ever it comes out VBA will
return. So many college and Universities go on MS's case about dumping
VBA that the next version Office will have VBA advantages put back in
even if they have to sacrifice some new fancy bell and whistle they
intended to put in.


If you have more than one drive I would suggest keeping 2004 on one and
putting 2008 on the other.

I've read about the VBA functions being removed from Excel 2008 and that
covers a big area of difference, but I'm wondering what else is different
between these two versions. Are all the Excel 2007 built-in functions also
available in 2008 or is there a list somewhere that shows which functions are
missing?

Also do charting and pivot tables function the same in 2007 and 2008, or are
there some differences? If the latter, any suggestions as to where I can
find a list of the differences?

I'm really looking to understand functional differences as opposed to user
interface differences.

Any suggestions would be appreciated.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Ted M H]

Hi Phillip,

Thanks so much for taking the time to reply. I'm actually trying to find a
source where I can see an inventory of functional differences between the two
versions. I need something a bit more methodical and complete than a couple
of sessions with users can give me. That might be something I try as a last
resort.

I've got to think that someone somewhere has sat down and listed out the
main differences.

As an aside, I bet you're wrong about Microsoft bending to pressure from the
Apple user community. I bet Micorsoft intends to force advanced Excel users
to run Windows on their Macs if they want to use the full version of Excel.
VMWare and Parallels products are just about there now and aside from the
distaste for Microsoft and the license fees they'll have to pay, users will
find it a tolerable experience to use windows if they have to to run Excel.
Excel has become the only game in town for serious spreadsheet users.
Microsoft wields that fact like a hammer--wait and see.

 

[Ted M H]

Hi Phillip,

Thanks so much for taking the time to reply. I'm actually trying to find a
source where I can see an inventory of functional differences between the two
versions. I need something a bit more methodical and complete than a couple
of sessions with users can give me. That might be something I try as a last
resort.

I've got to think that someone somewhere has sat down and listed out the
main differences.

As an aside, I bet you're wrong about Microsoft bending to pressure from the
Apple user community. I bet Micorsoft intends to force advanced Excel users
to run Windows on their Macs if they want to use the full version of Excel.
VMWare and Parallels products are just about there now and aside from the
distaste for Microsoft and the license fees they'll have to pay, users will
find it a tolerable experience to use windows if they have to to run Excel.
Excel has become the only game in town for serious spreadsheet users.
Microsoft wields that fact like a hammer--wait and see.

 

[Phillip Jones]

It wasn't just the Joe Average user that turned the tide.

For some strange reason MS didn't take into consideration Colleges and
Universities. Many top College people, from students on up to top Brass
Complained about the missing features VBA included. They had no idea
That probably more colleges and Universities use Mac's Than they do PC's.
So they are the ones That were Threatening to do bodily harm (just
kidding was not quite that rough) if it wasn't brought back. but between
feedback request and probably phone calls I imagine MS collective ears
were burning.

Hi Phillip,

Thanks so much for taking the time to reply. I'm actually trying to find a
source where I can see an inventory of functional differences between the two
versions. I need something a bit more methodical and complete than a couple
of sessions with users can give me. That might be something I try as a last
resort.

I've got to think that someone somewhere has sat down and listed out the
main differences.

As an aside, I bet you're wrong about Microsoft bending to pressure from the
Apple user community. I bet Micorsoft intends to force advanced Excel users
to run Windows on their Macs if they want to use the full version of Excel.
VMWare and Parallels products are just about there now and aside from the
distaste for Microsoft and the license fees they'll have to pay, users will
find it a tolerable experience to use windows if they have to to run Excel.
Excel has become the only game in town for serious spreadsheet users.
Microsoft wields that fact like a hammer--wait and see.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>