Kevin,

Excel 2002 cannot handle repeated subtotaling and removing
of subtotals. You may not need to do that often (if atl
all) when you are using a spreadsheet for information. but
when you are designing a spreadsheet, do the
subtotal/remove subtotal function more than twice, and it
crashes Excel (not just your workbook), something is
really wrong.

Microsoft knows about the error and according to one of
their Knowledge Base articles, "fixed" the problem in XL
2002 Service Pack 3. Only the fix isn't really a fix.

When I started discussing this with some of our techies,
they said they had run into even more egregious problems
with XL 2002, the worst being errors when importing or
exporting external data. All of the techies here who use
Excel a lot have "downgraded" to XL 2000 because of its
relative stability.

I have posted all of the above information in the
Worksheet Functions newsgroup, and didn't really want to
get into it here. My primary question for this board is:

What differences should I anticipate between XL 2000 and
XL 2002 when writing macros and designing management
reports?

"Working around" subtotals isn't really an option at this
point, because we are talking about 5000-7500 rows of data
that must be subtotaled by e.g. customer name. Pivot
tables are unacceptable to management because they cannot
drill down to detail.

And I don't attach my macros to the workbook itself. All
macros are stored in personal macro workbook, with code
then copied and pasted to a Word doc on the network for
everyone to use. Code is already clean.

The problem is NOT with the macros -- the problem was with
XL 2002.

Back to my original question: Now that I am working out of
Excel 2000, what problems or issues should I anticipate
for people who have Excel 2002 on their machines, besides
the ones I already know about? How do the two differ?

Best,

Denise.
Malvern, Pennsylvania