B
Bob Newman
Any major differences between Excel 2000 & Excel XP?
Bob
Bob
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harald Staff
Bob Newman said:Any major differences between Excel 2000 & Excel XP?
Hi Bob.
No. See http://j-walk.com/ss/excel/index.htm for an overview.
Best wishes Harald
G
George Nicholson
One thing I've noticed that John doesn't mention is the improvement in how
Excel handles memory.
For example, I've seen instances where apps that update a lot of Pivot
tables will run fine in Office XP but run *very* poorly or even hang in
Office 2000 (on machines with otherwise similar specs), requiring addition
of "dumb it down" workarounds to ensure usablity by both Office platforms.
Of course, these workarounds wouldn't be necesssary if everyone using the
app would upgrade to XP but too many of them say "it isn't worth it".
<Sigh.> Oh well, I get paid by the hour.
Excel handles memory.
For example, I've seen instances where apps that update a lot of Pivot
tables will run fine in Office XP but run *very* poorly or even hang in
Office 2000 (on machines with otherwise similar specs), requiring addition
of "dumb it down" workarounds to ensure usablity by both Office platforms.
Of course, these workarounds wouldn't be necesssary if everyone using the
app would upgrade to XP but too many of them say "it isn't worth it".
<Sigh.> Oh well, I get paid by the hour.
H
Harald Staff
Hi George
Bob asked for "major differences" and what's major is maybe a question of
what you use it for. The two (three, including 2003) are certainly
compatible.
I use Excel at times for washing huge lists of data, manually or by code,
formulas rarely involved, but mostly I do pretty small spreadsheet apps with
formulas, userforms and code. For this use, the versions (2000, XP, 2003)
are identical to me, and I use all three, almost at random without thinking
much about which one's running at the moment.
However, I know users who work with heavy big spreadsheets stuffed with
formulae, see XP as a huge improvement, and I don't doubt this. I believe
both memory handling, calculation handling and function assitiance is far
better.
So if this is a "worth upgading ?" question, yes, no, depending on what you
do with her. Major differences, well yes, no,... But a file made in one will
run on the others (with very few exceptions, and those would be VBA code
related).
Best wishes Harald
Bob asked for "major differences" and what's major is maybe a question of
what you use it for. The two (three, including 2003) are certainly
compatible.
I use Excel at times for washing huge lists of data, manually or by code,
formulas rarely involved, but mostly I do pretty small spreadsheet apps with
formulas, userforms and code. For this use, the versions (2000, XP, 2003)
are identical to me, and I use all three, almost at random without thinking
much about which one's running at the moment.
However, I know users who work with heavy big spreadsheets stuffed with
formulae, see XP as a huge improvement, and I don't doubt this. I believe
both memory handling, calculation handling and function assitiance is far
better.
So if this is a "worth upgading ?" question, yes, no, depending on what you
do with her. Major differences, well yes, no,... But a file made in one will
run on the others (with very few exceptions, and those would be VBA code
related).
Best wishes Harald
R
Robin Milford
Could you point me to more details on the VBA code related exceptions in your
post? I have a spreadsheet loaded with VBA macros which runs OK in Excel 97
at work, or Excel XP at home, but which fails and closes Excel when
recalculating under Office 2000 at work.
post? I have a spreadsheet loaded with VBA macros which runs OK in Excel 97
at work, or Excel XP at home, but which fails and closes Excel when
recalculating under Office 2000 at work.