On Feb 2, 1:11*am, Brettjg wrote:
Hello out there. I'm currently using XP 2003 with Excel 2003 and I've got a
particular suite of pretty intricate spreadsheets that use about 1mb of VB
code.

I've heard that upgrading to Excel 2007/Vista is not so easy to do because
of incompatibility, and I don't want the grief of a complete
rewrite/modification. On the other hand I'm sick to bloody death of Excel
2003 crashing because it feels like it.

What are your thoughts please? I'm happy to hear many views on this.
Regards, Brett.

I have used both Excel 2003 and Excel 2007 extensively. I prefer
Excel 2003. However, I have not had the same "crashing" experiences
that you obviously had. Excel 2007 is much slower and 2003, and it
offers pretty close to zero improvements in functionality. The
"ribbon" system is different than the drop down menu style, but it
isn't better. The only positive difference I have noted so far is
that the spreadsheets are much larger. This may be why it takes
sometimes 5 seconds to save a document. And 2007 produces (by
default) documents in a format which is unreadable by 2003. This may
be an effective business strategy, but it is a horrible idea for
software development. You can modify the default type to match Excel
2003. I wouldn't recommend Excel 2007. In my opinion, Excel 2003 is a
better system.

I dislike xl2007 as much as the next man, not much thought went in to
what users really want and find useful, however, take a look at some of
the function changes, some of you have been screaming out for them, to
take one example, you are no longer limited to 7 IF statements, in fact
the have incorporated a function called IFS() and COUNTIFS(), there are
some improvements, granted speed isn't one of them but take a deeper
look and you will find some things that make it worth while.

Andrew;209410 Wrote:
On Feb 2, 1:11*am, Brettjg wrote:
Hello out there. I'm currently using XP 2003 with Excel 2003 and I've
gota
particular suite of pretty intricate spreadsheets that use about 1mb
of VB
code.

I've heard that upgrading to Excel 2007/Vista is not so easy to do
because
of incompatibility, and I don't want the grief of a complete
rewrite/modification. On the other hand I'm sick to bloody death of
Excel
2003 crashing because it feels like it.

What are your thoughts please? I'm happy to hear many views on this.
Regards, Brett.

I have used both Excel 2003 and Excel 2007 extensively. I prefer
Excel 2003. However, I have not had the same "crashing" experiences
that you obviously had. Excel 2007 is much slower and 2003, and it
offers pretty close to zero improvements in functionality. The
"ribbon" system is different than the drop down menu style, but it
isn't better. The only positive difference I have noted so far is
that the spreadsheets are much larger. This may be why it takes
sometimes 5 seconds to save a document. And 2007 produces (by
default) documents in a format which is unreadable by 2003. This may
be an effective business strategy, but it is a horrible idea for
software development. You can modify the default type to match Excel
2003. I wouldn't recommend Excel 2007. In my opinion, Excel 2003 is a
better system.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57386

Thanks for your thoughts Andrew

"Andrew" wrote:

On Feb 2, 1:11 am, Brettjg wrote:
Hello out there. I'm currently using XP 2003 with Excel 2003 and I've got a
particular suite of pretty intricate spreadsheets that use about 1mb of VB
code.

I've heard that upgrading to Excel 2007/Vista is not so easy to do because
of incompatibility, and I don't want the grief of a complete
rewrite/modification. On the other hand I'm sick to bloody death of Excel
2003 crashing because it feels like it.

What are your thoughts please? I'm happy to hear many views on this.
Regards, Brett.

I have used both Excel 2003 and Excel 2007 extensively. I prefer
Excel 2003. However, I have not had the same "crashing" experiences
that you obviously had. Excel 2007 is much slower and 2003, and it
offers pretty close to zero improvements in functionality. The
"ribbon" system is different than the drop down menu style, but it
isn't better. The only positive difference I have noted so far is
that the spreadsheets are much larger. This may be why it takes
sometimes 5 seconds to save a document. And 2007 produces (by
default) documents in a format which is unreadable by 2003. This may
be an effective business strategy, but it is a horrible idea for
software development. You can modify the default type to match Excel
2003. I wouldn't recommend Excel 2007. In my opinion, Excel 2003 is a
better system.