D
Denise
Last week, I had to go back to Excel 2000 because Excel
2002 has too many unfixed errors, primarily in the data
subtotal worksheet function. (Our IT team did in fact
install Service Pack 3, but the issue persists. They have
replicated the errors.)
Now that I have Excel 2000, I am finding small differences
between Excel 2000 and Excel 2002 that affect the macros I
write to streamline and simplify large accounting reports.
For example, Excel 2002 seems to have a limit set on the
size of macros; macros that run fine on my computer stop
working on (networked) PCs that have Excel 2002. I have to
split these very long macros into two parts for them to
work in Excel 2002. And yes, the macros have been cleaned
up to get rid of unneeded code.
Since my machine has Excel 2000 on it, and all of my
bosses for whom the reports and macros are being generated
have Excel 2002, what conflicts can I expect in addition
to the ones mentioned above? It would be nice to be
prepared...
Best,
Denise.
Malvern, Pennsylvania
2002 has too many unfixed errors, primarily in the data
subtotal worksheet function. (Our IT team did in fact
install Service Pack 3, but the issue persists. They have
replicated the errors.)
Now that I have Excel 2000, I am finding small differences
between Excel 2000 and Excel 2002 that affect the macros I
write to streamline and simplify large accounting reports.
For example, Excel 2002 seems to have a limit set on the
size of macros; macros that run fine on my computer stop
working on (networked) PCs that have Excel 2002. I have to
split these very long macros into two parts for them to
work in Excel 2002. And yes, the macros have been cleaned
up to get rid of unneeded code.
Since my machine has Excel 2000 on it, and all of my
bosses for whom the reports and macros are being generated
have Excel 2002, what conflicts can I expect in addition
to the ones mentioned above? It would be nice to be
prepared...
Best,
Denise.
Malvern, Pennsylvania