Clearing cells takes long, long time
In . com,
unclemuffin spake thusly:
I am using Excel 2007 and I have a sheet that has about 22,000 rows of
data. When I try to delete the data by all of the following methods
it takes well over three minutes to complete:
Try going into Options / Calculation and switching it to manual
mode.
If that helps, you can turn calculation mode off in a macro that helps
you delete, then turn it back on.
=dman=
|