Excel 2000/Excel 2002

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

Bruce Roberson

Are the file formats for Excel 2000 and Excel 2002 identical? In other
words, if I create a spreadsheet in Excel 2002, will I be able to call it up
in Excel 2000 with everything intact assuming I don't use features that 2002
has that 2000 doesn't have?

And, would the same be true for the other office products?

Just checking before I make a switch..
 
Bruce,

Yes, it's okay.

But why switch? What does XL2002 have specifically that you want? If it is
significant enough to warrant switching, why not wait until XL2003 (due out
in Oct I believe).
 
I don't know how long they will keep us on Excel 2000 at work, but at home,
I think its time to upgrade from Excel 97 before it becomes obsolete. Since
I have the opportunity to move to XP, I'll take advantage of that and worry
about XL2003 later.
 
Bruce,

I read somewhere recently that Office97 is still the most oft-used Office
application out there, so I think Excel97 has some mileage yet.

In my experience, most of the additions in Excel 2000 and (especially) 2002
would not warrant spending good money on, but the more alarming (perhaps
that is a bit over-stated, but I'll use it anyway) is developing in
Excel2002 and finding that it doesn't work it Excel97. As an example, I
recently created a dynamic drop-down based upon data validation, that is 2
lists, the second of which was dependent upon the first and changed when the
first gets selected. I was suing Worksheet Change event code, and I found
that in Excel 2000, selecting a value from a data validation list triggered
that event, but in Excel 97 it doesn't, so I had to force it another way.

Moral - if you are developing for other versions, it's often best to develop
on the lowest version possible (although I think I'll stop at XL97, anyone
with XL95 can go whistle<vbg>).
 
Back
Top